We are working with a client looking to update a google spreadsheet.

The issue is the row to be updated can vary depending on information coming from their ERP system.

To do the update we need to read the spreadsheet and track the row read, and as far as their API goes there is not a simple approach.

We have set up a For Each to process the spreadsheet and an IF to find the matching row.

We need to count the reads to determine the actual row to be updated, we thought about Setting  Variable, but does not appear to be working well.  Any thoughts or suggestions would be appreciated. 

Thank you in advance!

Brian Silverman


------------------------------
Brian Silverman
------------------------------

Hi Brian,

App Connect's programming model is write once/read many, so it's not easily possible to alter or increment a variable like that.

Without knowing the specifics of your requirements, I wonder if you can use the 'Row number' field that comes from each Google sheets row?
You should have access to that on any node within the 'For each' block:



Hope that helps!

Ash

------------------------------
Ashley Harrison
------------------------------

Original Message:
Sent: Mon March 15, 2021 05:45 PM
From: Brian Silverman
Subject: Setting up a counter in App Connect Pro in the Cloud

We are working with a client looking to update a google spreadsheet.

The issue is the row to be updated can vary depending on information coming from their ERP system.

To do the update we need to read the spreadsheet and track the row read, and as far as their API goes there is not a simple approach.

We have set up a For Each to process the spreadsheet and an IF to find the matching row.

We need to count the reads to determine the actual row to be updated, we thought about Setting  Variable, but does not appear to be working well.  Any thoughts or suggestions would be appreciated. 

Thank you in advance!

Brian Silverman


------------------------------
Brian Silverman
------------------------------

Original Message:
Sent: 3/23/2021 2:26:00 PM
From: Ashley Harrison
Subject: RE: Setting up a counter in App Connect Pro in the Cloud

Hi Brian,

App Connect's programming model is write once/read many, so it's not easily possible to alter or increment a variable like that.

Without knowing the specifics of your requirements, I wonder if you can use the 'Row number' field that comes from each Google sheets row?
You should have access to that on any node within the 'For each' block:



Hope that helps!

Ash

------------------------------
Ashley Harrison
------------------------------

Original Message:
Sent: Mon March 15, 2021 05:45 PM
From: Brian Silverman
Subject: Setting up a counter in App Connect Pro in the Cloud

We are working with a client looking to update a google spreadsheet.

The issue is the row to be updated can vary depending on information coming from their ERP system.

To do the update we need to read the spreadsheet and track the row read, and as far as their API goes there is not a simple approach.

We have set up a For Each to process the spreadsheet and an IF to find the matching row.

We need to count the reads to determine the actual row to be updated, we thought about Setting  Variable, but does not appear to be working well.  Any thoughts or suggestions would be appreciated. 

Thank you in advance!

Brian Silverman


------------------------------
Brian Silverman
------------------------------