Glide API set up in make.com

[Northbridge_Recruitm]

I’ve tried looking but cant find any topics already covering this. Does anyone have a screenshot or can help with the set up for using the glide API using a http module in make.com? i’ve been struggling trying to use the API thus far so some help to implement it reliably would be super appreciated,

Im trying to send a webhook which includes an email address, validate that email with a API call in make.com using a http module and then i want to update the same row again in a column set up to record the API result in Glide.

[ThinhDinh]

I don’t remember if @Robert_Petitto ever has a video for this, but a HTTP call to update the row would look like this.

[Darren_Murphy]

@ThinhDinh

I don’t remember if @Robert_Petitto ever has a video for this

He has at least two

Glide API: Connect any platform to your Glide App!

[Glide API: Connect ANY platform to your Glide App!] In this video, we take a look at Glide’s newest feature—API integration! Imagine every time you receive a new tweet, payment, calendar booking, or file share, new records get added to your Glide app. With Glide’s API, this is possible in a matter of seconds. In this video, I present one example of connecting Calendly with a Glide app, but the possibilities are endless. Note: Glide API is limited to Pro/Enterprise level apps …

Use the Create JSON Module when using Make+Glide API

Hey all! If you’re a regular user of Make.com and you’re using it to write to Glide using Glide API, be sure to use the Create JSON module to prevent your Make scenarios from failing. Here’s how: [Use the Create JSON Module When Calling Glide API Via Make]

[Robert_Petitto]

You doubt

[Northbridge_Recruitm]

Thank you. I’ve looked through so many posts now i started to mix up the Glide API ones with the call API ones, and disregarded this thinking it was the latter

[Northbridge_Recruitm]

Im still having issues.

Im trying to edit a value in a column that is already in the table. Its a google sheets table, but i need the data immeditely, so cant wait for the routine refreshing to occur. I only want to update data in two data points, but leave the other columns unchanged.

Im triggering the webhook with one of the variables being rowID and the final set up of the http module is whats in trhe pic.

Im getting a status error 400 though with the data returned being:
"

Error

SyntaxError: Unexpected token } in JSON at position 248
    at JSON.parse (<anonymous>)
    at parse (/glide/node_modules/.pnpm/body[email protected]/node_modules/body-parser/lib/types/json.js:89:19)
    at /glide/node_modules/.pnpm/[email protected]/node_modules/body-...."
Can anyone tell me what ive done wrong in setting this up?

[Darren_Murphy]

That error is telling you that the JSON is malformed.
How are you generating the payload?
Are you using the Make Create JSON module as shown in Bob’s second video?

@Use the Create JSON Module when using Make+Glide API

Hey all! If you’re a regular user of Make.com and you’re using it to write to Glide using Glide API, be sure to use the Create JSON module to prevent your Make scenarios from failing. Here’s how: [Use the Create JSON Module When Calling Glide API Via Make]

[Northbridge_Recruitm]

I thought in the beginning of that video he explained that it was necessary when you were passing html or unicode to glide, but I am only passing text strings and email addresses so didnt think it applied. Ill give it a go though and see if it helps.

[Darren_Murphy]

I recommend using it no matter what, and especially if any of the content is user generated.
It’s not just HTML or unicode that can break JSON (actually, neither of those normally would break JSON). The most common things that will break JSON are multi-line text strings and unescaped double-quotes. Using the Create JSON module guarantees that those sorts of things are properly handled and ensures that your JSON is valid.

[Northbridge_Recruitm]

Thanks for the help. I tried two things - changing it to one item/row, and using the create JSON module as you recommended and now it works (not sure if one or both of those changes helped) but only when im working with a single row, but i cant get it to work properly with multiple items (i have a collection of arrays i want to add as a row each into glide). ive read through Set columns in multiple rows - Glide API as that post seemed relevant, but im not familiar with the iterator/aggregator and parse JSON modules (Im unfamiliar with Make.com really) so i feel like this are relevant but not sure if that would help me to get this to add multiple rows to Glide?