Hi, I am trying to use a scheduled server-side script to get the result every minute. I have set up the schedule on FMS. It runs without error which can be confirmed on the log. However, I cannot get the expected result.
When I try to execute the schedule immediately or run it once. I could get the expected result.
Does anyone know the reason behind that? Thank you.
The FMS version is 188.8.131.52, I am trying to execute Google Form API to get responses from a form.
Way too short on details to help out. Please tell us more.
First remember that some script steps do not work when running on Server
Also, remember that SSS (or PSoS) scripts are basically run as an entirely separate user connection. This has some implications:
- the context (Table, Records, Sort order, etc.) is not inherited, it has to be scripted to be set up
- the permissions could be different (for SSS, it's whatever user account you run the script as)
- if you are trying to use SSS to inject data into a record, if the record is currently open by the current FMPro (or WebDirect) user, it will fail since the record is locked.
- add more logging - have your SSS script log information about every step (I set up a dedicated Log table for this, but there are many ways to do it
Thanks, it seems I found the issue by trapping the error of the api.
It seems that there was an issue of the timestamp which should be in Zulu format.
FileMaker will omit the second if it is 0 second so I have to use serialIncrement to include 00 in my solution.
Thank you all the suggestions above.