Sending a bigquery table as CSV to API endpoint

Matillion ETL
1

Hi all,

Hoping to get some initial ideas for a non developer , to be able to do the following:

Send a bigquery table as a CSV file to an API endpoint with the following requirements:

POST https://admin.scarabresearch.com/hapi/merchant/<merchant-id>/sales-data/api

You must upload the sales data .csv file as a

binary (data-binary) payload in the request body.

CURL example:

curl --request POST \

--header 'Authorization: Bearer <token> \

--header 'Content-type: text/csv' \

--header 'Accept: text/plain' \

--data-binary @/myhome/salesdata-2018-03-26.csv \

https://admin.scarabresearch.com/hapi/merchant/<id>/sales-data/api

Can this be done with Matillion API Extract Manager or perhaps a bash or python script?

Thanks!

2

Hi @JRomej​

Thanks so much for posting your question! I believe a Python Script would be the best call for what you're after.

Many thanks,

Claire