API Query Profile returns HTTP Bad request 400

Matillion ETL
1

Logs give no details apart from a stack trace showing an exception HTTP Bad request 400. Tho the same configuration works in the Query Profile wizard.

 

My configuration:

<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="UIO" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">

  <!-- You can modify the name, type, and column size here. -->

  <attr name="account_id" xs:type="string" readonly="false"       other:xPath="/json/data/account_id" />

  <attr name="ad_id"    xs:type="string" readonly="false"       other:xPath="/json/data/ad_id"    />

  <attr name="adset_id"  xs:type="string" readonly="false"       other:xPath="/json/data/adset_id"  />

  <attr name="campaign_id" xs:type="string" readonly="false"       other:xPath="/json/data/campaign_id" />

  <attr name="clicks"   xs:type="string" readonly="false"       other:xPath="/json/data/clicks"   />

  <attr name="cpc"     xs:type="string" readonly="false"       other:xPath="/json/data/cpc"     />

  <attr name="ctr"     xs:type="string" readonly="false"       other:xPath="/json/data/ctr"     />

  <attr name="date_start" xs:type="date"  readonly="false"       other:xPath="/json/data/date_start" />

  <attr name="date_stop"  xs:type="date"  readonly="false"       other:xPath="/json/data/date_stop"  />

  <attr name="frequency"  xs:type="string" readonly="false"       other:xPath="/json/data/frequency"  />

  <attr name="impressions" xs:type="string" readonly="false"       other:xPath="/json/data/impressions" />

  <attr name="reach"    xs:type="string" readonly="false"       other:xPath="/json/data/reach"    />

  <attr name="region"   xs:type="string" readonly="false"       other:xPath="/json/data/region"   />

  <attr name="spend"    xs:type="string" readonly="false"       other:xPath="/json/data/spend"    />

 </api:info>

 

 <api:set attr="DataModel" value="DOCUMENT" />

 <api:set attr="uri" value="https://graph.facebook.com/v12.0/123456789/insights" />

 

 <api:set attr="JSONPath" value="/data" />

 

 <!-- 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="method" value="GET"/> <!-- HTTP request type -->

  <api:call op="jsonproviderGet">

   <api:push/>

  </api:call>

 </api:script>

 

 

 

 

</api:script>