Solved: Webhooks and for functions

FREDY_ORTEGON · 07-05-2019 07:11 AM

Hello everyone, is it possible to use functions like “for” and loop in the body where the content is JSON type?

I would like to make an action in table A and activate a webhook that copies “N” times a record in table B

Phil

Try it now. I replaced “NUEVOS MANTENIMIENTOS” with “NUEVOS%20MANTENIMIENTOS”.
When there is a space in a table name it needs to be url encoded.

View solution in original post

Phil

You can use << Start >> and << End>> in a JSON template to create multiple records. See topic “Creating a JSON Body Template File with <> and <> Tags” in this article https://help.appsheet.com/en/articles/962008-invoking-webhooks-from-a-workflow-rule-or-scheduled-rep...

FREDY_ORTEGON

Hello Phil, I was doing tests with the start and the end and they work . But, now I have another problem, in my workflow I need to add a new record in the table “CXP” and this record has enabled the option “copy until December” must invoke a webhook that copies 12 times that record is finished to add. the only thing is that in each registration the field “month of income” must change from January to December. Would it be possible to do this?

Phil

I am not sure from your description, but one idea is to include 12 records in your webhook template. The first would be for January, the second would be for February, and so forth.

FREDY_ORTEGON

You mean create 12 different webhook actions?

Phil

I thought you were trying to insert 12 similar records, one for each month.
If so, my suggestion was to create a JSON template that contains those 12 records.
The first record of the 12 would be for January, the second would be for February, etc.
All 12 records would be submitted in one REST API request.
If you did this, you may no longer need to use a << Start >> and << End >> in the JSON template.

FREDY_ORTEGON

Hi Phil, I don’t know if appsheet has modified anything in the web hooks ?, because the documentation with the PEOPLE and PEOPLE ECHO tables is no longer in the documentation and my weebhook that was already working, now it doesn’t work.

Phil

I am not aware of any changes to webhooks.

What error are you seeing in Audit History?

FREDY_ORTEGON

please look this

Phil

Try it now. I replaced “NUEVOS MANTENIMIENTOS” with “NUEVOS%20MANTENIMIENTOS”.
When there is a space in a table name it needs to be url encoded.