UID creation via Workato (automatization of creation UID)

[Sultanbek]

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?

[gary1 · Accepted solution]

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.

https://developers.google.com/sheets/api/samples/rowcolumn#insert-row-column

[Sultanbek · Accepted solution]

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.

[gary1]

Woah, thanks for sharing! I had no idea this existed.