Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Unable to parse json data
MavenHi, I am trying to fetch data from a API using "get_webpage". The website respods with a json array. No I am not able to use "cut document" to get specific values from the response by writing json queries.
I use the query : $.result.accountStatistics[0].
<?xml version="1.0" encoding="UTF-8"?><process version="7.5.001">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="7.5.001" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="web:get_webpage" compatibility="7.3.000" expanded="true" height="68" name="Twitter" width="90" x="45" y="34">
<parameter key="url" value="https://api.
<parameter key="accept_cookies" value="all"/>
<list key="query_parameters"/>
<list key="request_properties"/>
</operator>
<operator activated="true" class="text:cut_document" compatibility="7.5.000" expanded="true" height="68" name="Cut Document" width="90" x="246" y="34">
<parameter key="query_type" value="JsonPath"/>
<list key="string_machting_queries"/
<list key="regular_expression_
<list key="regular_region_queries"/>
<list key="xpath_queries"/>
<list key="namespaces"/>
<list key="index_queries"/>
<list key="jsonpath_queries">
<parameter key="TotalIntercationCount" value="$.result.
</list>
<process expanded="true">
<connect from_port="segment" to_port="document 1"/>
<portSpacing port="source_segment" spacing="0"/>
<portSpacing port="sink_document 1" spacing="0"/>
<portSpacing port="sink_document 2" spacing="0"/>
</process>
</operator>
<connect from_op="Twitter" from_port="output" to_op="Cut Document" to_port="document"/>
<connect from_op="Cut Document" from_port="documents" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
Json response :
{
"status":200,
"result":{
"accountStatistics":[
{
"account":{
"id":1653853,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":6,
"
"likeCount":625
"retweetCount":
},
"breakdown":{
"native_video":
"
"postCount":
"
"likeCount":
"
},
"link":{
"
"postCount":
"
"likeCount":
"
},
"tweet":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":26
}
},
{
"account":{
"id":76760,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":3,
"
"likeCount":91,
"retweetCount":
},
"breakdown":{
"photo":{
"
"postCount":
"
"likeCount":
"
},
"tweet":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":37
}
},
{
"account":{
"id":1545626,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":2,
"
"likeCount":10,
"retweetCount":
},
"breakdown":{
"link":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":65
}
},
{
"account":{
"id":2042715,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":1,
"
"likeCount":8,
"retweetCount":
},
"breakdown":{
"photo":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":30
}
},
{
"account":{
"id":2236790,
"platform":"
"platformId":"
},
"summary":{
},
"breakdown":{
},
"subscriberData":{
"initialCount":
"finalCount":29
}
}
],
"pagination":{
}
}
}
"status":200,
"result":{
"accountStatistics":[
{
"account":{
"id":1653853,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":6,
"
"likeCount":625
"retweetCount":
},
"breakdown":{
"native_video":
"
"postCount":
"
"likeCount":
"
},
"link":{
"
"postCount":
"
"likeCount":
"
},
"tweet":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":26
}
},
{
"account":{
"id":76760,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":3,
"
"likeCount":91,
"retweetCount":
},
"breakdown":{
"photo":{
"
"postCount":
"
"likeCount":
"
},
"tweet":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":37
}
},
{
"account":{
"id":1545626,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":2,
"
"likeCount":10,
"retweetCount":
},
"breakdown":{
"link":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":65
}
},
{
"account":{
"id":2042715,
"platform":"
"platformId":"
},
"summary":{
"
"postCount":1,
"
"likeCount":8,
"retweetCount":
},
"breakdown":{
"photo":{
"
"postCount":
"
"likeCount":
"
}
},
"subscriberData":{
"initialCount":
"finalCount":30
}
},
{
"account":{
"id":2236790,
"platform":"
"platformId":"
},
"summary":{
},
"breakdown":{
},
"subscriberData":{
"initialCount":
"finalCount":29
}
}
],
"pagination":{
}
}
}
Please help.
Tagged:
0
Answers
Seems it is expecting a double dot, this works :
$.result.accountStatistics[0]..
As an alternative you can also just cut on the accountStatistics and then use a json to data component as below example, this makes it a bit more easy to work with the full set of data.