Add a row with API Webhook

[Johny_Freitas]

Hi guys, i want to use the API to add a new row at my app.

i create the workflow and is all working
but when i send the POST to add the row, it’s add too many rows, how could i solve it?

[Marc_Dillon]

I see nothing wrong with your JSON.
Perhaps for some reason the webhook is being sent multiple times?

Also, thanks for showing me Insomnia

[Johny_Freitas]

yeah, when i send the post i get multiples values

[GreenFlux]

Do the AppSheet logs show the API being invoked multiple times per ‘POST’ from Insomnia?

Any chance other actions/workflows are duplicating records?

Try changing the URL to a Postbin so you can see if multiple POSTs are sent there too.

[LeventK]

@Johny_Freitas
Key column is missing in your JSON payload…You need to specify the key column and its value at the beginning. In below page, refer to Section: Body :: Item#3

help.appsheet.com

Adding Records to a Table

How to add records using the API.

[Johny_Freitas]

i saw it, but my key column is uniqueid and at that page i found it “if the key field contains an “Initial value”, you can omit the key field value”

anyway, i tried to put the key column and i get the same error:

[LeventK]

Johny_Freitas:

i tried to put the key column and i get the same error:

With “…same error…” are you referring to getting multiple records?
A second thought is trying with removing the RunAsUserEmail parameter from the payload.

[Johny_Freitas]

Hi guys, i solved it, changing the preset from add row to custom, now works greats