Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

"Could not parse request body" error using python airtable wrapper

Solved
Jump to Solution
3437 1
cancel
Showing results for 
Search instead for 
Did you mean: 
aaron_bell
5 - Automation Enthusiast
5 - Automation Enthusiast

I am using python to run sum calculations and data summaries at various sub-groupings. This is being done using python pandas and the data format is a dataframe. I have to convert this dataframe to a list according to the airtable python wrapper documentation, which I have used before, just not the dataframe part.

After converting to a list, I am getting this error

requests.exceptions.HTTPError: (‘422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2’, “422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2 [Error: {‘type’: ‘INVALID_REQUEST_BODY’, ‘message’: ‘Could not parse request body’}]”)

is anyone familiar with this any why it is happening?

1 Solution

Accepted Solutions
aaron_bell
5 - Automation Enthusiast
5 - Automation Enthusiast

UPDATE: Python Pandas had some NaN values, this needed to be converted to 0. Airtable then accepted the list.

See Solution in Thread

1 Reply 1
aaron_bell
5 - Automation Enthusiast
5 - Automation Enthusiast

UPDATE: Python Pandas had some NaN values, this needed to be converted to 0. Airtable then accepted the list.