Cannot upload PDF-attachments with CURL


#1

Background.

I have Valuations field in my Airtable DB. It’s type is set to “Attachment” and it stores PDFs. I populate it manually.

Script.

I’ve got a VBA-script with embedded CURL-commands that works as follows:

  1. Record values in several fields
  2. Delete all rows.
  3. Insert new sample enriched with the recorded data in rows with matching IDs, i.e. from step 1.

Problem.

Despite the fact that I have recorded the JSONs of each attachment in “Valuations” I get #422 Error whenever I launch my CURL to create an updated record containing attachments in “Valuations”. Please, have a look at the JSON below. Any advice will be highly appreciated.

“Valuations”:[
{
“id”:“attGR7hW7A3jnIczu”,
“url”:“URL…pdf”,
“filename”:“Valuation-Workbook_3284-3286-Sullivant-Ave-Columbus-OH-43204_2018-12-27-11-11-09 (1).pdf”,
“size”:8244890,
“type”:“application/pdf”,
“thumbnails”:{
“small”:{
“url”:“URL…pdf”,
“width”:36,
“height”:36},
“large”:{
“url”:“URL…pdf”,
“width”:512,
“height”:512}
}
}
]


#2

Me too, please anyone HELP!


#3

Try using only the “url” and “filename” parameter.
Perhaps the size, width, height etc are not matching up with Airtable’s calculation of said file…not sure though.

Are you able to directly update/create the record via curl on your terminal?


#4

Airtable needs your files to be hosted on a webserver. So you cannot use a url that is from your filesystem. Where are the files hosted?