How to Send JSON Body Without Value Names?

Support
1

Hi,

I want to send the following JSON body in a web API. How can I do this in Triggre without needing to include the value names?

{
“values”: [
[
“12:00 AM”,
“Name Last”,
“Globe”,
“Company”,
“No Reason”,
“2000”,
“c:/”
]
]
}

Kind regards,
Melissa

2

Hi Melissa,
Currently it’s not possible to do that with Triggre. In general it’s quite strange for me to send it like this, since the order of the values will matter a lot.

Maybe it’s possible using the Webhook functionality of Zapier.

1 Like
3

The issue here is not the ordering, but the fact dat Google Sheets API Append needs an array in an array.
We are looking for a way to accomplish this.

Unfortunately, in this use case Zapier is not an option.

4

Hi @ronald,

There currently doesn’t seem to be a compatible solution in Triggre indeed. We’ll look into this with the development team. It is a case we haven’t run into yet, nameless arrays inside another array. Or nameless values in general, for that matter.

That being said, I think there is a temporary solution:

Create a PHP script that can convert a JSON structure that Triggre can make, into one that is compatible with Google Sheets, sends it to Google Sheets (without needing to know which sheet etc, that can be sent as data to the script), and returns the exact same structure it gets back from Google to Triggre.

That way, when we have resolved the issue, you can remove this ‘proxy’ script and send data to Google Sheets directly, without having to change a lot in the design.

Would it be an option?