02-05-2024 12:58 PM
We have a use case where we need to import revenue transactions from Intacct to Anaplan via Workato using Unique ID for each transaction. Could you please suggest me how can Workato create an Unique ID (UID) to each new transaction for import?
Solved! Go to Solution.
02-06-2024 08:57 AM
The Sheets API has an endpoint for this. It's not supported by the Workato connector, but you should be able to use the custom action to call the endpoint and make the update.
02-12-2024 07:01 AM
If someone has the same question regarding creation of UID in workato there is useful formula called "workato.uuid" or you can create your own by using the "encode_base64" formula.
02-05-2024 01:09 PM
I don't know of a native way to do it in Workato, but you can use an HTTP action to call this API and generate one for free.
https://www.uuidgenerator.net/
For example, just call https://www.uuidgenerator.net/api/version4/500 and you get 500 freshly generated UUIDs
02-06-2024 05:19 AM
@gary1 Thank you for your advice! I wonder if we can create an action of adding new columns in google sheet for example? Do you have any insights?
02-06-2024 08:57 AM
The Sheets API has an endpoint for this. It's not supported by the Workato connector, but you should be able to use the custom action to call the endpoint and make the update.
02-06-2024 10:13 AM
Many thanks! I will try