Airtable error messages when I try adding a URL

How To
, , ,
1

I’m trying to build a content calendar that’ll allow me to repurpose content to different platforms, check there are no duplicates, give performance metrics, etc. The first stage of the process is to write a new idea, select a pillar and format, then hit “Go”.

Img4
Img41774×882 61.8 KB

At the moment, I’m unable to insert the Google Doc link into the Airtable module. I’ve tried adjusting the field type in Airtable to URL and long text, but I’m getting the same errors every time.

The latest record should create the document for a WordPress post.

Here is my scenario in Make:

Img1
Img11326×892 47.5 KB

Everything else runs smoothly, except for the last Airtable module. Here’s what I’m using from the Google Doc output…

Img2
Img21009×637 55.3 KB

And this is what I’m trying to do with it…

Img3
Img3840×894 63.9 KB

Which gives me the following error message…

[422] Cannot parse value "[{“url”:"https://docs.google.com/document/d/1Dc7kUIGBHeG3F_YC6VDnPBl5XBgVdk6fvj1EREY9zGo/edit?usp=drivesdk"}]" for field Document Link

I’ve tried mapping the Web View Link from the Google Doc output to the “Document Link” in the Airtable module too. But that just gives me this error…

Validation failed for 1 parameter(s).

  • Array of objects expected in parameter ‘fldVZmPjxnR1Byg4k’.

Any suggestions would be much appreciated. Cheers!

1 Like
2

Heyy @StevieB

Web view link is not Direct download link.

You can use Links available under Export Links section of Doc output.

image
image862×907 62.4 KB

And map that URL in Airtable inputs as that link is Direct download link.

image
image436×502 21.1 KB

I hope this Helps!

Best,
@Prem_Patel

1 Like
3

Hi @StevieB,

while @Prem_Patel is 100% right with the download links, usually that would result in the attachment column being empty because Airtable cannot download it.

The error message gives you a column ID “fldVZmPjxnR1Byg4k” - which column is that in your table?
A guide to finding field/column IDs is here: Finding Airtable IDs | Airtable Support (finding multiple IDs)

I feel like a different column than the attachment column isn’t setup correctly :slight_smile:

Best,
Richard