Template : how to use data from a webhook to add row in Glide app

[Ludovic_M]

I try to add multiples rows in Glide Table by using a webhook Glide and https requests
All necessary informations for the call API is provided with the webhook.
I search a template which does something similar.

Call API

curl --request POST ‘https://api.glideapp.io/api/function/mutateTables’
–header ‘Content-Type: application/json’
–header 'Authorization: Bearer ***’
–data-raw '{
“appID”: "pZ",
“mutations”: [
{
“kind”: “add-row-to-table”,
“tableName”: “native-table-ANLUcAcAMqoZTzE0elRP”,
“columnValues”: {
“gj6dW”: “”,
“Name”: “Task 1”
}
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-ANLUcAcAMqoZTzE0elRP”,
“columnValues”: {
“gj6dW”: “”,
“Name”: “Task 2”
}
}, {
“kind”: “add-row-to-table”,
“tableName”: “native-table-ANLUcAcAMqoZTzE0elRP”,
“columnValues”: {
“gj6dW”: “”,
“Name”: “Task 3”
}
}

Include screenshots of

• your scenario setup (functions, mappings, variables, etc.)
• module configurations and outputs
• any error messages you are getting

[samliew]

Welcome to the Make community!

Have you tried the “Make an API Key Auth Request” module?

If you need more assistance, please provide the following:

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

^{(Note: Exporting your scenario will not include private information or keys to your connections)}

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[Ludovic_M]

Thanks for your response.
I will try it.

[Ludovic_M]

The http request works !
Thanks a lot for your suggestion and your screenshot.
I still have to work out how to map the webhook data to dynamically feed the request content.

[Ludovic_M]

With the webhook, there is an issue with the parameter to map for Request content.

For the 1rst case, I have a BundleValidationError
For the 2nd case, status code is 400. Request content is considered as empty

Solved ! The problem was a bad naming of parameter in Glide

Thanks @samliew !

[Michaela]

Heya @Ludovic_M welcome to the community

I’m just quickly stepping in to say awesome work getting this up and running with the assistance of @samliew

Thanks a lot for circling back here and sharing your final solution for the benefit of the community. We all 100% appreciate it