I did a very partial test right now, and this seems to have set me on the right track. Thank you for your persistence.
1 Like
In your last comment, you did set me straight and I’ve made considerable progress, but there is still what I hope is one last piece of this puzzle to figure out.
In terms of making progress, the difference that made the difference is I now know that a DB field can contain a list of values returned by an API call.
So now, that list of returned values saves properly within the DB record:
and
and the scheduling of the API call on the list shows no errors
The last problem is, either the API workflow isn’t executing, or the Create a new action, which is the only action within the workflow, isn’t doing anything. I don’t know how to determine which it is, as once you’re in a backend workflow you can’t even send a console.log message as for backend workflow processes there is no webpage to send anything to.
And
How would you troubleshoot this further?
There’s a few thing you can check. Instead of sending it to current date and time, add +120 secondes (2minutes). Trigger the workflow and go in Logs and check Scheduled workflow. You should see data and items scheduled there.
In Server logs, you will also be able to see what happen when the item is processed in backend. This may help you.
Don’t forget to check privacy rules (you can try the "Ignore privacy rule when running this workflow in the schedule API workf on a list).
Good ideas. Will do. Thank you.
I’m not sure exactly what happened, but it looks like something good did. I took your advise and scheduled the API Workflow the current date/time + 120 seconds, then came back almost two hours later and saw it still scheduled.
I then realized they scheduled jobs were paused. I clicked resume. It ran.
The expected record was created five times, but I’m not sure if I had accidentally queued it up four times previously and when I selected Resume they somehow all resumed.
My next test will be to delete the newly created records and run from scratch.
I’ll let you know how it goes, but I want to thank you for your help in getting me this far.
It’s working great. Thank you again!!!
1 Like
Hi, this post was super helpful and I took all the steps in my out app but my data didn’t come in.
- I changed the “Use as” in the API to ‘Data’ instead of ‘Action’
- I made the database field the subtype
- Added the backend workflow Endpoint and used Schedule API Workflow on a list action and all the fields are blue
Any help on what I could be doing wrong would be awesome. Thanks again for the post.
Looks like it worked, but the log shows every was deleted right after it happened it happened and nothing is showing in the db field.
Any ideas on what to do here would be helpful; @Jici
Did you check privacy setting?
Got it working! Thank you
1 Like
Hey all, Im curious if theres a way to parse through that list instead of just accepting it as a list. Im trying to get the “offeringID” however because its nested in the “offeringDetails” (list) field. Is there anyway to parse through that?
So far I’ve tried clicking “Edit raw data” and remove the fields I didnt want but then it doesnt return anything when I actually try to make the call in a workflow.
Thanks again for your help!
1 Like