Skip to main content
  • EN


I have a
JSON file and need to extract the attributes from this file.


How can I
do it?



Example:

{

 

"id" : null,

 

"revisionNumber" : "1.0.0",

 

"periodTimeInterval" : {

 

"start" : "2014-10-10T01:00Z",

 

"end" : "2014-10-11T01:00Z"

 

},

 

"timeSeries" : u

 

{

 

"id" : "silo:67688:536653:raw",

 

"name" : null,

 

"tskeys" : null,

 

"dimensions" : {

 

"attribute" : b

 

{

 

"value" : {

 

"item" : o],

 

"type" : "String",

 

"value" : null

 

},

 

"name" : "Datenquelle"

 

},

 

{

 

"value" : {

 

"item" : /],

 

"type" : "Integer",

 

"value" : "0"

 

},

 

"name" : "Netzbetriebsplanung"

 

},

 

{

 

"value" : {

 

"item" :

 

{

 

"key" : "0",

 

"name" : "from",

 

"type" : "DatumZeit",

 

"value" : "1990-01-01T00:00:00.000"

 

},

 

{

 

"key" : "0",

 

"name" : "factor",

 

"type" : "Float",

 

"value" : "1"

 

},

 

{

 

"key" : "0",

 

"name" : "constant",

 

"type" : "String",

 

"value" : "0"

 

}

 

],

 

"type" : "Zeitwerte",

 

"value" : null

 

},

 

"name" : "Bilanzfaktor"

 

},

 

{

 

"value" : {

 

"item" : Â],

 

"type" : "NotizRtf",

 

"value" : null

 

},

 

"name" : "Notiz"

 

},

 

{

 

"value" : {

 

"item" : p],

 

"type" : "NotizUnformatiert",

 

"value" : null

 

},

 

"name" : "Zeitreihenqualit_t"

 

},

 

"measures" : {

 

"attribute" :

 

{

 

"value" : {

 

"item" : 🙂,

 

"type" : "int",

 

"value" : "67688"

 

},

 

"name" : "abfrageid"

 

},

 

{

 

"value" : {

 

"item" : >],

 

"type" : "int",

 

"value" : "536653"

 

},

 

"name" : "zeitreiheid"

 

},

 

{

 

"value" : {

 

"item" : &],

 

"type" : "string",

 

"value" : "RAW"

 

},

 

"name" : "datenquelle"

 

},

 

{

 

"value" : {

 

"item" : e],

 

"type" : "string",

 

"value" : "OHNE"

 

},

 

"name" : "datenausgerollt"

 

},

 

],

 

"name" : null

 

},

 

"period" : q

 

{

 

"timeInterval" : {

 

"start" : "2014-10-10T01:00Z",

 

"end" : "2014-10-11T01:00Z"

 

},

 

"resolution" : "PT60M",

 

"point" : -

 

{

 

"datumZeitUTC" : 1507597200000,

 

"position" : 1,

 

"quantity" : 45.48

 

},

 

{

 

"datumZeitUTC" : 1507600800000,

 

"position" : 2,

 

"quantity" : 43.69

 

},

 

{

 

"datumZeitUTC" : 1507604400000,

 

"position" : 3,

 

"quantity" : 42.41

 

}

 

]

 

}

 

]

 

}

 

]

 

}






Thank you
very mutch for any suggestions.



Zoran

There is a wrong syntax in your json example.

Hi @zoran68, generally you can use JSON reader or JSON*** transformers to parse a JSON document. The way depends on what fearture(s) you need to extract from the document.

Note: As @jneujens mentioned, your document is not a valid JSON. Please post a valid JSON document if you expect a more specific answer.

Hi @zoran68, generally you can use JSON reader or JSON*** transformers to parse a JSON document. The way depends on what fearture(s) you need to extract from the document.

Note: As @jneujens mentioned, your document is not a valid JSON. Please post a valid JSON document if you expect a more specific answer.

testdaten-forum.jsonHi takashi, I think this is the copy paste Problem.

 

I attached the sample file and hope at the help.

 

 

testdaten-forum.json

I attached the sample data and hope you can help me.

Thanks

Zoran

testdaten-forum.json

I attached the sample data and hope you can help me.

Thanks

Zoran

The document still contains wrong syntax. Any software cannot parse it unfortunately.

Reply


Community Stats

30,102
Posts
114,259
Replies
37,732
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.