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

[gary1]

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

[Sultanbek]

@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?

[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]

Many thanks! I will try