I followed the instructions on this page: [image] Call API | Glide Docs Send and receive data from API endpoints. I did this [Screenshot 2024-12-03 at 18.32.29] I don’t get one record per row I get this [Screenshot 2024-12-03 at 18.32.48] How do I get …

Which specific bits of information are you interested in? Actually, let’s just say you want the title of each one. I’d probably use a JavaScript column, like this: [CleanShot 2024-12-03 at 16.50.55@2x] const json = JSON.parse(p1); return json.data[p2].title; If you need some other attributes, d…

My man :raised_hands: { "success": true, "data": [ { "id": "c0b059d0-b144-11ef-ac0b-c76b0d4251c7", "title": "Fruit Co lead", "owner_id": 22602236, "creator_id": 22602236, "label_ids": [], "value": null, …

API docs Yes it returns a collection with metadata

Thanks. I can’t use any of the json integrations to query data out of a record? Also, use case is: label a lead in pipedrive crm, then only those records appear in glide. If I am getting diff data each time I call api, then I assume the static row numbers in glide table won’t matter right?

[image] blairrorani: Thanks. I can’t use any of the json integrations to query data out of a record? You could use the Query JSON column, but that would require an extra template column to combine the row index with the attribute. So I find it easier to use a JavaScript column. [image] bl…

Do you think glide will create a native solution for this? Must be reasonable common.

[image] Darren_Murphy: const json = JSON.parse(p1); return json.data[p2].title; Wait do I need that template column for my JSON? Or can I use the call API column? Oh is that to strip out the meta data?

Yes, just use the output of your Call API column as the p1 parameter in the JavaScript column.

[Screenshot 2024-12-03 at 21.41.29] Error? I only retrieved one record via my api call (intentionally), does that matter?

Generally you can ignore that error. You’ll get it if the p1 value is empty on any row, or if you have more rows than items in the JSON collection.

got it thx mate, I’ve added logic to my JS to check values exist to avoid this. Basically building this for a client. Summarise lead based on CRM data Add notes in Glide and sync to CRM Draft follow up email based on notes

Get rows of data into glide via call api

Ask for Help

Darren_Murphy December 9, 2024, 1:23am 21

Topic		Replies	Views
Call API, Multiple records Ask for Help	2	331	November 18, 2023
Use Rest API calls as DATA Ask for Help	12	1535	March 22, 2023
Api interaction Ask for Help	4	540	May 13, 2022
Integrating Glide App with Pipedrive CRM via AI Transcriptions Ask for Help data-sync , api	24	1136	July 30, 2023
Using Call API and Glide API to add rows to related tables. Also...JSON Object! Project Showcase tutorial	14	1067	September 5, 2024

Get rows of data into glide via call api

Related topics