Adding a list row [V 3.0] connector - Google Sheet

[dba...@momnet.com]

I'm using the new SEC to get data from my SQL Server database and populate a Google Sheet. The project is using the 'Adding a list row [V 3.0]' connector.
Sometimes the process works fine and other times it generates the following error: "Error while processing {results + [P_result.entry]}
Expression P_result.entry is undefined on line 1, column 14 in Add data to Google Spreadsheet." It's retrieving all the rows correctly from the SEC call into an array named [records_list]. In the Add to Google Sheet task I'm looping through the ${records_list} with an input variable of entry which is assigned ${records_list[P_index]}.

It may run one day and populate, for example, all 300 rows into the Google Sheet with no error. But the next day it may only populate 23 in the Google Sheet before creating the above error message.

Any help in troubleshooting is appreciated.
Thank you,

[Richard Manga]

Hi,

It seems that sometimes, you don't have an existing entry in the record.

I suggest you to use a default value in your freemarker code to manage those cases:

results+ [P_result.entry?default("")] : if P_result.entry is a string, or

results+ [P_result.entry?default({})] : if P_result.entry is  a JSON.

Regards,

Richard

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/2dce3c2b-daef-41d1-9028-ef37d05660cd%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Dave Bandy]

Thank you.

You received this message because you are subscribed to a topic in the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/WdFzwKnXCz4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAJ6Gss_friM%2B0CtRfTibUr%3D5y4D%2BUK7SKTEepFbFafmMzchbaA%40mail.gmail.com.