Skip to main content
To homepage To homepage
Solved

Unable to get root/node value

J
Starter

Goodmorning,

currently I am trying to extract data from a REST API. However the JSON response is structured oddly. In the image below you can see a sample, the numerical values (704, 1406, 1517) whcih represent userID's, aData represents a JSON Object.

I am able to extract the aData data. However I am not able to get the corresponding numeric values, since they are not a key:value pair. I suspect I am doing something wrong with my JSONPath and/or xpath. Below is party of my RSD file (except the methods):

<api:info title="data" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">    <!-- You can modify the name, type, and column size here. -->    <attr name="_id"xs:type="integer"readonly="false"  key="true"other:xPath="/_id"/>    <attr name="ID"xs:type="string"readonly="false"other:xPath(".")/>    <attr name="aData"xs:type="string"readonly="false"other:xPath="/*"/>    <input name="fromdate"xs:type="string"default=""/>  </api:info>  <api:set attr="DataModel" value="RELATIONAL" />  <api:set attr="JSONPath" value="*" />  <api:set attr="URI" value=">REDACTED<" />

Is there any way to extract those numerical values and add them to a (new) column?

Best answer by Thomas Lind

Hi Jasper

If you first add the the numbers you can also use it in the a Data table you get out of it.

Write a support ticket to us, if you want a more specific solution.

View original
    Did this topic help you find an answer to your question?

    3 replies

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1034 replies
    • June 29, 2021

    Hi Jasper

    Is the numbers in an specific order and could you get them as a list in a get call?

    If so you could probably do a loop of these numbers to only get the aData part.

    J
    Starter
    • j.brancart
    • Author
    • Starter
    • 1 reply
    • June 29, 2021

    Hi Thomas,

    I receive them from lowest to highest.I think this is a result of a 'ORDER BY' in their DB, and the order does not really matter. The data also changes every week. Without the values the data is worthles, bercause I need them to create a relation between users and their aData.

    My other option is to contact the API provider and ask them to change the API. I am not sure though, because I am quite new to TimeXtender.

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1034 replies
    • Answer
    • June 30, 2021

    Hi Jasper

    If you first add the the numbers you can also use it in the a Data table you get out of it.

    Write a support ticket to us, if you want a more specific solution.

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings