# I haven't been able to get the following API call to work in Matillion:

**URL:** <https://matillioncommunity.discourse.group/t/i-havent-been-able-to-get-the-following-api-call-to-work-in-matillion/2014>\
**Category:** Matillion ETL\
**Created:** [January 11, 2023, 10:48pm UTC](https://matillioncommunity.discourse.group/t/i-havent-been-able-to-get-the-following-api-call-to-work-in-matillion/2014 "2023-01-11T22:48:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![BenPalacios](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@BenPalacios](https://matillioncommunity.discourse.group/u/BenPalacios)\
**Post date:** [January 11, 2023, 10:48pm UTC](https://matillioncommunity.discourse.group/t/i-havent-been-able-to-get-the-following-api-call-to-work-in-matillion/2014/1 "2023-01-11T22:48:24Z")

</div>

curl code:

curl --location --request POST 'https://api.monday.com/v2' \

--header 'Authorization: auhorization\_key

&nbsp;

it works in Postman fine.

&nbsp;

.rsd file I generated:

\<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema"\>

&nbsp;

&nbsp;\<!-- See Column Definitions to specify column behavior and use XPaths to extract column values from JSON. --\>

&nbsp;\<api:info title="VOC3" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1"\>

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

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

&nbsp;&nbsp;\<attr name="id"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;xs:type="string" readonly="false"&nbsp;&nbsp;&nbsp;other:xPath="/json/data/boards/items/id"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/\>

&nbsp;&nbsp;\<attr name="field"&nbsp;&nbsp;&nbsp; &nbsp;xs:type="integer"&nbsp;readonly="false"&nbsp;&nbsp;&nbsp;other:xPath="/json/data/boards/items/id/colmun\_values/id"&nbsp;&nbsp;&nbsp;&nbsp;/\>

&nbsp;&nbsp;\<attr name="field\_value"&nbsp;xs:type="integer"&nbsp;readonly="false"&nbsp;&nbsp;&nbsp;other:xPath="/json/data/boards/items/id/colmun\_values/value"&nbsp;&nbsp;&nbsp;&nbsp;/\>

&nbsp;\</api:info\>

&nbsp;

&nbsp;\<api:set attr="DataModel" value="DOCUMENT" /\>

&nbsp;\<api:set attr="uri" value="https://api.monday.com/v2" /\>

&nbsp;

&nbsp;\<api:set attr="JSONPath" value="/data/boards/items" /\>

&nbsp;

&nbsp;\<!-- 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. --\>

&nbsp;\<api:script method="GET"\>

&nbsp;&nbsp;\<api:set attr="method" value="POST"/\> \<!-- HTTP request type --\>

&nbsp;&nbsp;\<api:set attr="data"\>

{"query":"query { boards(ids:3381227481){ name items { id column\_values { id value } } } }"}

&nbsp;&nbsp;\</api:set\>

&nbsp;&nbsp;\<api:set attr="ContentType" value="application/json" /\>

&nbsp;&nbsp;\<api:call op="jsonproviderGet"\>

&nbsp;&nbsp;&nbsp;\<api:push/\>

&nbsp;&nbsp;\</api:call\>

&nbsp;\</api:script\>

\</api:script\>

---

<div class="post-metadata">

**Author:** ![winston.l](https://avatars.discourse-cdn.com/v4/letter/w/8797f3/32.png) [@winston.l](https://matillioncommunity.discourse.group/u/winston.l)\
**Post date:** [April 7, 2023, 11:14pm UTC](https://matillioncommunity.discourse.group/t/i-havent-been-able-to-get-the-following-api-call-to-work-in-matillion/2014/2 "2023-04-07T23:14:30Z")

</div>

Hi Ben,

&nbsp;

Hope you have resolved this already, but if you haven't, do give this a try:

- In your API Query component that runs the Query Profile, under Connection Options, try add 'CustomHeaders' under Parameter
- Then add value 'Authorization: Bearer xxxxx' where xxxx is your auhorization\_key
- Example: 
- 

- I used a variable instead of actual value - the variable value is refreshed by another job

&nbsp;

Hope this helps.

&nbsp;

Cheers

Winston