I have a custom connector which I am creating a output field schema for.The HTTP response is JSON in the following format:{ Key: [ [ "string", "string2", "..." ] ], Key2: "String", Key3: "integer", }Here is a samp...
Generating a unique email/useridsource: BambooHRdestination: OKTA/EntraIDHas anyone setup a workflow to add a new user (John Smith) to OKTA when there may already be a John.Smith@company.com userid/email present in the system and then to cycle throug...
Hi All,Is there a builtin function to look for duplicate entries in a table? I'm sure I had found a Lookup Table to do this but can no longer find it.Thanks in advance for you help
Hi, I have the following workflow:User triggers recipe from workbot in slack by typing "create data"Slack workbot sends link to google sheet for user to fill outOnce that google sheet is filled out, I need another recipe to be triggered, using the da...
I have a recipe where I am pulling invoices from the past 2 years. I want to add a condition where it will only pull records for 10 customers. I have not been very successful in setting up a formula using customer ID's. I have attached a copy of the ...
There are tons of junk 2, 3 step recipes in the community that are useless for building anything substantial. I wish there were a way to rate the community recipes or moderate them and remove them if they are worthless.
I have an API that returns me certain items with corresponding dates.They come in this format : 2024-06-12T13:00:00.000+02:00When I turn them into a SQL collection, all is well.However I get an issue when I query the SQL collection, as it suddenly re...
Hi,I have a view in SQL that shows a schedule (production order) with its startdate and update date (the update date does not always mean that the production order has started, just that something has been updated).What I want to do is find a schedul...
Hi,I'm looking to use the Workato connector for Quickbooks to upload an image to later attach.I'm following these notes but have not been able to solve it Attach images and notes (intuit.com).I'm using a custom action with the Quickbooks connector.He...
What resources or study material would you recommend for someone preparing for the Salesforce Certified Administrator certification?
