I created a flow that adds records in airtable. Flow works partially because it creates records and then it gives me following error massage.
i looked at datasets and saw that one of the datasets has a empty values in it and i think it causes the problem.
Could you please help me with this issue?
hello @heimwerkertools ,
Can you check at which field you are referring here?
The red error is complaining about the field „Quantity Price 1“.
What value are you trying to send there?
@synesty-Sales thank you for your respond!
yes, field Quantity Price 1 contains number values and empty value. I check this field in airtable too. Flow works till 70th line and then stops and gives this error massage. I check the field the only thing that values are empty.
Thanks for your feedback. We could reproduce the error with a „number“ field in Airtable.
Can you please try again.
We deployed a fix which better handles empty values.
Just for the record: Now our step sends
"fieldname" : null to the Airtable API in case a column value is empty.
@synesty-Sales thank you!
Unfortunately, i got another error massage concerning other field. The problem with this field, i think , is that this field has sting values für first 100 datasets and number values for rest.
I don’t know if it is something that you also can change or fix. Please respond as soon as possible! Thank you!
Can you post examples? that would be helpful.
Thanks for the info. It seems the mix is the problem. We will get back to you and try to find a fix.
We made a small adjustment on how numeric fields are handled. Can you please retry?
It seems the permission for „Schema Read“ is missing in your personal access token.
Can you please check:
- Go to https://airtable.com/create/tokens
- Go into your token (or create a new one)
- Make sure that scope
schema.bases:read is in the list of Scopes.
@synesty-Sales thank you the flow worked