Arduino Cloud, some webhooks do not include all variables

Development Tools Cloud IoT
1

I am using Webhook to send my Arduino Cloud variables to a Google Apps script which then writes to a Google sheet.
All of the 8 Arduino Cloud variables are updated by the Nano 33 iot each 30 sec.
In Setup all the 8 Cloud variables are declared to to be updated periodically each 30 secs.
Every webhook payload sent seems to contain only some of the 8 cloud vars and generally if not always(?) 2 payloads are sent within a 1 or 2 sec interval. The script can handle this if each payload contains a unique incremented identifier. However there are occasions when the incomplete payload data arrives and one of the missing variables is the sequence number which is incremented each 30sec by the nano. The 8 variables include the sequence number which is used in the Google script to recognize/identify a new update. If the sequence number is missing from a payload then the script discards the received data as it does know which google sheet row should be written.

The console.log function of the Google scripts shows the incomplete webhook data.

DEBUG 2025-07-01T05:27:34.798257Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:27:34.799965Z Received data for Sequence #: 3555
DEBUG 2025-07-01T05:27:35.146668Z Sequence # 3555 not found. Appending new row.
DEBUG 2025-07-01T05:27:57.533698Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:27:57.535241Z Received data for Sequence #: 3555
DEBUG 2025-07-01T05:27:57.855105Z Found existing Sequence # 3555 at row 1441. Updating.
DEBUG 2025-07-01T05:28:05.146712Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:28:05.149257Z Received data for Sequence #: 3556
DEBUG 2025-07-01T05:28:05.468635Z Sequence # 3556 not found. Appending new row.
DEBUG 2025-07-01T05:28:32.418805Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:28:32.420566Z Received data for Sequence #: 3556
DEBUG 2025-07-01T05:28:32.883336Z Found existing Sequence # 3556 at row 1441. Updating.
DEBUG 2025-07-01T05:28:34.987888Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:28:34.990325Z Payload did not contain 'sequenceNumberCloud'. Cannot proceed.
DEBUG 2025-07-01T05:28:35.455518Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:28:35.456691Z Received data for Sequence #: 3557
DEBUG 2025-07-01T05:28:36.676379Z Sequence # 3557 not found. Appending new row.
DEBUG 2025-07-01T05:28:36.754745Z Carrying forward sSID: xTimeCapsule
DEBUG 2025-07-01T05:29:03.081653Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:29:03.084239Z Payload did not contain 'sequenceNumberCloud'. Cannot proceed.
DEBUG 2025-07-01T05:29:05.075926Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:29:05.078150Z Received data for Sequence #: 3558
DEBUG 2025-07-01T05:29:05.422900Z Sequence # 3558 not found. Appending new row.
DEBUG 2025-07-01T05:29:05.853034Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:29:05.855471Z Received data for Sequence #: 3557
DEBUG 2025-07-01T05:29:06.170003Z Found existing Sequence # 3557 at row 1440. Updating.
DEBUG 2025-07-01T05:29:34.818522Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:29:34.820434Z Received data for Sequence #: 3559
DEBUG 2025-07-01T05:29:35.630200Z Sequence # 3559 not found. Appending new row.
DEBUG 2025-07-01T05:29:41.987142Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:29:41.992668Z Received data for Sequence #: 3558
DEBUG 2025-07-01T05:29:42.651038Z Found existing Sequence # 3558 at row 1440. Updating.
DEBUG 2025-07-01T05:30:05.069813Z --- New Execution (v7.1 - Carry Forward) ---
DEBUG 2025-07-01T05:30:05.071977Z Received data for Sequence #: 3560
DEBUG 2025-07-01T05:30:05.513089Z Sequence # 3560 not found. Appending new row.

How do you control the webhook so that all 8 variables are sent to the Google script in a single payload or always include the sequence number in a partial webhook?
Is this timing issue which can corrected by altering the nano/cloud update frequency?

2

I have deleted your other cross-post @mackarduino.

Cross-posting is against the Arduino forum rules. The reason is that duplicate posts can waste the time of the people trying to help. Someone might spend a lot of time investigating and writing a detailed answer on one topic, without knowing that someone else already did the same in the other topic.

Repeated cross-posting can result in a suspension from the forum.

In the future, please only create one topic for each distinct subject matter. This is basic forum etiquette, as explained in the "How to get the best out of this forum" guide. It contains a lot of other useful information. Please read it.

Thanks in advance for your cooperation.

3

I apologise for not knowing the posting rules.
This post is more relevant to the Cloud IoT category. Can it be transfered?

4

I have moved the topic to the Development Tools > Cloud IoT forum category as you suggested.

5

One of the 8 variables in my Nano 33 iot app is an Arduino type String.

I have now deleted this var from the Nano and the Arduino Cloud. This action appears (so far) to have eliminated the Webhook payloads which had to be discarded as they excluded a sequence number.
The remaining 7 vars are standard types int, float and bool.

Perhaps the var type String is not entirely suitable for use with a Arduino Cloud Webhook and therefore it is best not to use it?