Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Solved
Jump to Solution
1422 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.