About MikeZ

MikeZ · 11-20-2020

Hi, I have a Workflow Action to a webhook to POST to a Rest API. The json data is a parent/child. The UX interface and the underlying data entered into Google Sheets is fine. However, the webhook template is not passing any child records. Any trouble...

MikeZ · 09-29-2020

Hi, I am trying to use REF/Dereference to look up an item code from a given barcode number. The lookup table consists of a key column with the barcode number and an item code column. My app takes user input for the barcode number. This is a Ref colum...

MikeZ · 11-21-2020

Ok, it seems that an invalid body template must be cached. The most recent template is referenced in the workflow action, and it looks fine when I view it. However, the payload in the log entry is totally different, obviously from a prior version. An...

MikeZ · 11-21-2020

That could work, but I think i solved it by ensuring the REF column is included in the template for the child records. I had to figure out where to “put it” on the server application side, but that worked out as well. Thanks for all the ideas! Mike

MikeZ · 11-21-2020

When I excluded the child REF from the template, the payload had the header for the child records, then empty When I put the child REF column back in the template, I got a payload with a valid child record. Here’s the payload with the missing child d...

MikeZ · 11-21-2020

Thanks for the ideas, tried them all now, with no luck. It seems that when I remove the REF child field from the template, which I do not need for the webhook, the child lines don’t get generated. So it seems that Appsheet uses the webhook body templ...

MikeZ · 11-20-2020

Thanks, John, for looking. I did “hide” a couple of columns before it stopped working so maybe the workflow bugs out if it doesn’t see them? The columns that were hidden do show in the log of the API call. The server just throws a 4xx code because it...

My Stats

MikeZ's Bio

Badges MikeZ Earned

Recent Activity

Webhook Template not picking up child records

Reference/Dereference list

Re: Webhook Template not picking up child records

Re: Webhook Template not picking up child records

Re: Webhook Template not picking up child records

Re: Webhook Template not picking up child records

Re: Webhook Template not picking up child records