cURL POST request not working as python requests equivalent

Question

I have a curl POST request that returns a CSV in the terminal as expected. The following format is provided in the RJMetrcis documentation (see "Export figure data"). Here is the curl request in bash:

curl --data-raw "format=csv&includeColumnHeaders=1" -H "X-RJM-API-Key: myapikey" https://api.rjmetrics.com/0.1/figure/12345/export

Alternatively, using -d instead of --data-raw also works

However, when replicating this with the help of a previous post using requests in Python, an error is returned:

url = "https://api.rjmetrics.com/0.1/figure/12345/export"

payload = "'{\"format\":\"csv&includeColumnHeaders=1\"}'"
headers = {
  'X-RJM-API-Key': 'myapikey'
}

response = requests.request("POST", url, headers=headers, params=payload)
response.text

'{"Error":"Invalid Argument: CSV is currently the only supported format for SQL Reports"}'

This is a specific error returned by the API indicating a CSV format is not requested (when -d is left out of the bash command, the same error is raised). However, both requests are syntactically the same. What could be the Python issue here? Is there a preferred method to pass parameters?

αԋɱҽԃ αмєяιcαη · Accepted Answer · 2020-10-04 05:28:22Z

2

import requests

data = {
    'format': 'csv',
    'includeColumnHeaders': 1
}

headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:81.0) Gecko/20100101 Firefox/81.0',
    'X-RJM-API-Key': 'yourapi'
}


def main(url):
    r = requests.post(url, data=data, headers=headers)
    print(r)


main("https://api.rjmetrics.com/0.1/figure/12345/export")

answered Oct 4, 2020 at 5:28

αԋɱҽԃ αмєяιcαη

11.6k3 gold badges23 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cURL POST request not working as python requests equivalent

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related