I'm sending data to Google Execution API - I've got function in scripts to get parameter in json and put it in new Google Sheet. With small data it is working without a problem but I have big data to export - For example JSON that is sent in problematic export has 580k lines when formatted like this:
[
{
"productionDate": "12/08/2016",
"legacyCode": null,
"quantity": 1,
"customer": "tst1",
"customerAddress": "add1",
"addressLegacyCode": "AD1"
},
{
"productionDate": "12/08/2016",
"legacyCode": null,
"quantity": 1,
"customer": "cust2",
"customerAddress": "add1",
"addressLegacyCode": "AD2"
}
]
Does anyone of you know if there is a specific limit for length of parameter to be send to google.
I'm getting error:
[16-08-12 09:45:01:364 CEST] Starting execution
[16-08-12 09:45:01:373 CEST] Execution failed: Script function not found: [0 seconds total runtime]
