I am trying to get data from Business Central dimensionSetLines for generalLedgerEntry using a cdata REST connector.

I have copied the functionality for nested API call from https://support.timextender.com/data%2Dsources%2D112/advanced%2Drsd%2Dfile%2Doptions%2D884?tid=884#Using+nested+calls+to+get+data+from+multiple+pages.

However, I get error message: Â500] Could not execute the specified command: Formatter r file_id ] failed in the evaluation of ffileout.file_id]. The error was:
The value of the attribute could not be accessed: The attribute does not exist.

Can you see anything wrong about the file?

timeXtender version is 20.10.26.64

 

<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="GetAllStops" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">
    <!-- You can modify the name, type, and column size here. -->
    <attr name="code"                   xs:type="string"  readonly="false"              other:xPath="/json/value/code"                   />
    <attr name="id"                     xs:type="string"  readonly="false"              other:xPath="/json/value/id"                     />
    <attr name="parentId"               xs:type="string"  readonly="false"              other:xPath="/json/value/parentId"               />
    <attr name="valueCode"              xs:type="string"  readonly="false"              other:xPath="/json/value/valueCode"              />
    <attr name="valueId"                xs:type="string"  readonly="false"              other:xPath="/json/value/valueId"                />
  </api:info>

  <api:set attr="urlbase" value="https://api.businesscentral.dynamics.com/v2.0/{tenantId}/production/api/v2.0/companies({companyId})" />
  <api:set attr="filein.DataModel" value="DOCUMENT" />
  <api:set attr="filein.JSONPath" value="$.value" />
  <api:set attr="filein.URITemplate" value="lurlbase]/generalLedgerEntries?$Select=Id"/>
  <api:set attr="filein.ElementMapPath#" value="/json/value/id" />
  <api:set attr="filein.ElementMapName#" value="file_id" />
  <api:set attr="stopin.DataModel" value="DOCUMENT" />
  <api:set attr="stopin.EnablePaging" value="TRUE" />
  <api:set attr="stopin.JSONPath" value="$.value" />
  <api:set attr="stopin.URITemplate" value="nurlbase]/generalLedgerEntries({file_id})/dimensionSetLines" />
  <!-- The GET method corresponds to SELECT. Here you can override the default processing of the SELECT statement. The results of processing are pushed to the schema's output. See SELECT Execution for more information. -->
  <api:script method="GET">
    <api:set attr="filein.URI" value="cfilein.URITemplate]" />
    <api:call op="jsonproviderGet" in="filein" out="fileout">
      <api:set attr="filein.file_id" value=""fileout.file_id]" />
      <api:set attr="stopin.URI" value=" stopin.URITemplate | replace('{file_id}',  filein.file_id])]" />
      <api:call op="jsonproviderGet" in="stopin" out="stopout">
        <api:set attr="out.code" value="'stopout.code | allownull()]" />
        <api:set attr="out.id" value="Gstopout.id | allownull()]" />
        <api:set attr="out.parentId" value=""stopout.parentId | allownull()]" />
        <api:set attr="out.valueCode" value="ustopout.valueCode | allownull()]" />
        <api:set attr="out.valueId" value=".stopout.valueId | allownull()]" />
        <api:push item="out"/>
      </api:call>
    </api:call>
  </api:script>
</api:script>