Skip to main content
To homepage To homepage

I have an API that requires an access token to be retrieved using a POST request, which is returned as JSON. Most of the endpoints also return the data in JSON, which I can already extract using custom rsd files. However, there is one endpoint that returns custom reports in text/CSV format. So I'm looking for a way to retrieve the token from a JSON response and use it to do a second request to retrieve a CSV response.

I've tried using the CSV provider to do this, but I get an error when I want to combine jsonproviderGet and csvproviderGet in a nested call using an rsd file based on my already working all-json rsd file:

 

Is there a way to make this work?

 

Thanks,

Jasper 

Hi @jasperp 

Cdata has advised using the REST 2023 provider rather than the CSV provider. Please add the following connection properties to the REST data source

Format=CSV;DataModel=Relational

and please add the following to the rsd file:

  <api:script method="GET">
    <api:call op="csvproviderGet">
      <api:push/>
    </api:call>
  </api:script>

 

Reply


Terms and ConditionsCookie settings