0

Select correct json data

Dennis Weimar Thrane

July 11, 2017 10:50

None

Follow

I'm new at klipfolio,

I have some json data from accuranker. How to I add a condition at the root with regex. Like how do I select keyword where id is 21049316?

 

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Larona Nyambe July 11, 2017 13:28

  Hi Dennis,

  Thanks for posting on our community forum! 

  You want to define some xpath to select your data : @/keyword[preceding-sibling::id=21049316];

  What that xpath does is select all the keywords where the preceding-sibling node id is 21049316. Here is a link to our document on xpath: https://support.klipfolio.com/hc/en-us/articles/215547118-About-JSON-and-XML-data-sources 

  Cheers,

  L.N

   

• 0
  
  Dennis Weimar Thrane July 12, 2017 06:52

  Thank you,

  What if I want to select @/history/rank where id is 21049316?

• 0
  
  Larona Nyambe July 12, 2017 14:10

  Hi Dennis,

  I don't see the node @/history/rank in your data set picture above. It would be much easier to help if we could see your data source, submit a support ticket to support@klipfolio.com. 

  Cheers,

  L.N

• 0
  
  Iris Panabaker December 24, 2018 06:06

  I would also suggest validating your JSON data using these tools.

  • https://jsonformatter.org 
  • https://codebeautify.org/jsonvalidator