API_DoQuery and response array with Google Scripts
I've been attempting to build a script on Google Scripts that will run daily and send notifications.
The concept behind it is that it should perform an API_DoQuery on a table that contains customer records, retrieving all customers that need to be sent a reminder.
I want to store those records in an array that i will then loop through, performing an API_editRecord on a checkbox field, sending an email to each customer reminding them they have pending documentation.
I've seen Kirk's video on how to use google scripts and have managed to use itfor API_EditRecord and AddRecord, but Do_Query and processing the results I've had no success with.
Any help, pointers, etc. would be much appreciated!!
thanks!
The concept behind it is that it should perform an API_DoQuery on a table that contains customer records, retrieving all customers that need to be sent a reminder.
I want to store those records in an array that i will then loop through, performing an API_editRecord on a checkbox field, sending an email to each customer reminding them they have pending documentation.
I've seen Kirk's video on how to use google scripts and have managed to use itfor API_EditRecord and AddRecord, but Do_Query and processing the results I've had no success with.
Any help, pointers, etc. would be much appreciated!!
thanks!
