Hi, I would like to develop an application to send data using API to a MS SQL Server. The data source is from pre-defined google sheet / Excel spreadsheet. The only issue I can’t understand is how to post data from the App to external Db (currently in MS SQL Server / AMAZON) using JSON format (I h…

You would need to use Glide computed columns to construct a JSON payload, and then send that via a webhook to an external service such as Make/Zapier, which could then forward it to your MS SQL Server API. Note however that webhooks in Glide must be user-initiated. That is, it would require an acti…

Thanks for the quick reply :slight_smile: No problem with user-initiation… As for the “construct a JSON payload”, I’m not familiar with that. Is there any tutorial/documantation/example on how to do that?

Well Darren, YOU ARE THE BEST !! Thanks

A short one if I may: Does Glide itself sends the webhook (button press is great for me) or do I need Make/Zapier to send it?

If you have a webhook action, when a user press the button, it will send the payload you choose to whatever URL you specify in the webhook action.

Hi Community We are using the get Row API and found that the return values are a mixture of ID and Column name. How can we make sure the that get values are column names ? [Column ID vs Names]

They are the Glide internal column names, and are guaranteed not to change. You should use them in your API calls. For example, if you rename a column in Glide, the internal column name will not change, and so your API integrations will not break.

Thanks for your prompt reply! Weird that some are with the name intact but some are in raw internal column name

Send data using API

Ask for Help

Darren_Murphy September 20, 2022, 3:44pm 4

No, but there is now

Webhook to Export user specific data/report

Send a batch of emails based on certain criteria

Topic		Replies	Views
API with Make (formerly Integromat) Ask for Help	12	2010	June 19, 2022
Push data from zapier into Glide table Ask for Help	10	723	January 25, 2023
Getting API response back from webhook Ask for Help	16	1815	August 11, 2023
How connect a webhook response direct with the column Ask for Help	3	60	November 13, 2025
Api interaction Ask for Help	4	559	May 13, 2022

Send data using API

Related topics