0

Select correct json data

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?

 

4 comments

  • 0
    Avatar
    Larona Nyambe

    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
    Avatar
    Dennis Weimar Thrane

    Thank you,

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

  • 0
    Avatar
    Larona Nyambe

    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
    Avatar
    Iris Panabaker

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

Please sign in to leave a comment.