Skip to main content
Solved

'Update' method of Airtable cURL API updates the given single field's value, but clears others' values

  • May 27, 2020
  • 4 replies
  • 40 views
K
Forum|alt.badge.img+7
  • Kartik11
  • Participating Frequently
  • 8 replies

Hi! :wave:
I am using the PUT version of the Airtable Update records API.

I have four columns/fields, Name , Contact , Attachment Image & Active.
Now I call the API to update just the Attachment Image column, with the below API body :

It updates the Attachment Image field’s value successfully, but clears all other fields. The record snapshots (before and after) look like -

  • Before -

  • After -

So, how can I make the API update that cell ONLY, and touch nothing else?

I hope you understand my query - Any help is appreciated! :slightly_smiling_face:
Thanks!

Best answer by kuovonne

What is your development platform? Can you send a PATCH request as a custom cURL request in your development platform?

If not, you may need to resort to the workaround of doing a read of all the fields in the record, and include them in your PUT request.

4 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • 6009 replies
  • May 27, 2020

You need to use a PATCH request instead of a PUT request.
:slightly_smiling_face:

If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details?

K
Forum|alt.badge.img+7
  • Kartik11
  • Author
  • Participating Frequently
  • 8 replies
  • May 27, 2020

You need to use a PATCH request instead of a PUT request.
:slightly_smiling_face:

If this answers your question, please mark this post as the solution. Otherwise, could you please give a bit more details?


Hi, @kuovonne! :smiley_cat:

Un-fortunately, we do not have a PATCH kind of request in our development platform - only POST, PUT, GET & DELETE requests.

Any other way around?
Thanks!

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • 6009 replies
  • Answer
  • May 27, 2020

What is your development platform? Can you send a PATCH request as a custom cURL request in your development platform?

If not, you may need to resort to the workaround of doing a read of all the fields in the record, and include them in your PUT request.

K
Forum|alt.badge.img+7
  • Kartik11
  • Author
  • Participating Frequently
  • 8 replies
  • May 27, 2020

What is your development platform? Can you send a PATCH request as a custom cURL request in your development platform?

If not, you may need to resort to the workaround of doing a read of all the fields in the record, and include them in your PUT request.


That would definitely work :smiley_cat:

Thanks a lot! :tada:
P.S. My platform is thunkable.com - do check it out! :slightly_smiling_face:


Terms & ConditionsAccessibility statement