REST API request with paramaters (list) based on previous request

Hi Thomas,

Thanks for your quick reply. First of all; thanks to the comprehensive guide. However, it's a bit overwhelming for me I think. I'm mixing up pagination with parameters, and now you introduce nested calls. Looks like the nested calls variant is more complex. Could you help me out with a sample based on the Post example, where you have two requests and you fill the {PostId} in the second query, based on the first one.
Assuming that I have two RSD's: locations and reviews. The first one contains a locationId, exactly like the PostId in the example. 
1) What should I add to the location RSD? (Should I add something??)
2) What shoud I add to the review RSD?
- input parameter:

<input name="locationId" xs:type="string" other:filter="{locationId}" />

- BaseUrl mapping:

api:set attr="BaseURI" value="https://blablapi.com/{locationId}" />

- map Location in custom parameter:

[locationId] IN (SELECT [locationId] FROM REST.json)

Sorry for the newbe question; like I said: I'm mixing up some things. Hope you point to the fault I'm making.

You should use my suggested method, but I can see you aren't doing it correctly. If you look at my guide for doing inputs, you need to call it in a different manner.

  <api:script method="GET">
<api:check attr="_input.datein">
      <api:set attr="URI" value="http://data.fixer.io/api/[_input.datein]?access_key=522b683569a91b66be6be214027b47bf"/> 
    </api:check>
    <api:call op="jsonproviderGet">
      <api:push/>
    </api:call>
  </api:script>

Exactly, I think that was my initial issue as well with the input method.

It might be possible if you mix the If and Page method with your input.
https://legacysupport.timextender.com/hc/en-us/articles/360052383191-Creating-and-using-RSD-files-for-CData-providers#IfandPage

So something like this.

<api:set attr="BaseURI" value="https://blablapi.com/{locationId}" />

<api:set attr="URI" value="[BaseURI]?page=[_input.rows@next]" />

Hi Thomas, do you have an example of the complete RSD? As where does the _input.datein come from for example.

  <api:script method="GET"><api:check attr="_input.datein">      <api:set attr="URI" value="http://data.fixer.io/api/[_input.datein]?access_key=522b683569a91b66be6be214027b47bf"/>     </api:check>    <api:call op="jsonproviderGet">      <api:push/>    </api:call>  </api:script>

I have the same as Thye has. I have 3 REST API's (json):

• GET /rest/v2/customers, output contains value of customer_id
• GET /rest/v2/locations?customer_id=1, output contains value of location_id. No api is available to get all locations at once, can only be done with mandatory parameter customer_id
• GET /rest/v2/devices?location_id=1, No api is available to get all devices at once, can only be done with mandatory parameter location_id

At the end I want to have all customers with all of their locations and devices of those locations. As a flat table or nested I don't care much. That's the next step for me.

P.S. De quality of the images on https://legacysupport.timextender.com/hc/en-us/articles/360052383191-Creating-and-using-RSD-files-for-CData-providers is too low to read unfortunately :(

This is my code right now with the gorest example api's, but still without any results.:

<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">	 <!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. -->	 <api:info title="JSONData" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">		<attr name="id" xs:type="integer" other:xPath="dummy" />		<attr name="title" xs:type="string" other:xPath="dummy" />	 </api:info>	 <api:set attr="UrlBase" value="https://gorest.co.in/public-api" />	 <api:set attr="customerin.DataModel" value="DOCUMENT" />	 <api:set attr="customerin.JSONPath" value="$." />	 <api:set attr="customerin.TemplateUri" value="[urlbase]/users"/>	 <api:set attr="customerin.ElementMapPath#" value="/json/data/id"/>	 <api:set attr="customerin.ElementMapName#" value="id"/>	 <api:set attr="trayin.Header:Name#" value="Accept"/>	 <api:set attr="trayin.Header:Value#" value="application/json"/>	 <api:set attr="trayin.DataModel" value="DOCUMENT"/>	 <api:set attr="trayin.JSONPath" value="$.data"/>	 <api:set attr="trayin.TemplateUri" value="[urlbase]//users/{customer_id}/posts"/>	 <api:set attr="trayin.ElementMapPath#" value="/json/data/title"/>	 <api:set attr="trayin.ElementMapName#" value="title"/>	<api:script method="GET">	 <api:set attr="customerin.URI" value="[customerin.TemplateUri]"/>		<api:call op="jsonproviderGet" in="customerin" out="customerout">			<api:set attr="trayin.URI" value="[trayin.TemplateUri | replace('{customer_id}',[customerout.id])]"/>			<api:call op="jsonproviderGet" in="trayin" out="trayout">				<api:set attr="out.id" value="[customerout.id]"/>				<api:set attr="out.title" value="[trayout.title | allownull()]"/>				<api:push item="out" />			</api:call>		</api:call>	</api:script></api:script>

Hi Peter

Yes, you can set up logging.
https://legacysupport.timextender.com/hc/en-us/articles/360001029663-Add-a-CData-data-source#set-up-a-log-for-extra-info

When you have the log file it will show what call it is trying to make.

You need to be sure the replace function gives the correct id and that the call for these are successfully.

Hi Peter
You can open a support ticket by emailing support@timextender.com