โ02-06-2024 07:51 AM
I have a case where we should import data from Intacct to Anaplan via Workato. However to do so, firstly we need to create an Unique UID in exporting data of Intacct through Workato. I know that workato has two formulas to generate such UID (UUID and .encode_base64). However I dont understand how I should use these formulas in order to update the export data from Intacct.
For example:
Intacct has the following transactions:
We need to create action to import this data to Anaplan on monthly basis since it will be updated every month.
Now we need to create a new column called "UID". Consequently the data from Intacct should look like:
According to the above, does anyone have an idea how it should be built in workato to create UID and add it as a new column in raw data?
#UUID #UID #Anaplan #Workato
Solved! Go to Solution.
a week ago
Hi @Sultanbek
Here is the solution:
1. Use "workato.uuid.encode_base64" to generate random UID and encode)
a week ago
I met same issue, does anybody know how to handle this in Workato? Thanks.
a week ago
Hi @Sultanbek
Here is the solution:
1. Use "workato.uuid.encode_base64" to generate random UID and encode)
a week ago
Dear @Sultanbek , @wayswssb.
To create a unique UID for each row in your Intacct data export within Workato, you can follow these steps:
1. Generate a Unique ID: Use random_bytes(16).encode_base64 to generate a 16-byte random string and encode it in Base64. This will give you a unique string each time itโs generated.
random_bytes(16).encode_base64
2. Combine with Existing Fields (Optional):
- If you want the UID to be derived from specific fields, combine columns like Date, Amount, and GL Account. For example:
([Date] + [Amount] + [GL Account]).encode_base64
- .encode_base64 will convert the combined string into a unique base64-encoded identifier.
3. Add UID to Each Row:
- Use the Workato formula to create the UID and add it as a new column in your data. You can add this UID in a `Create row` or `Update row` action for Anaplan.
Let me know if you'd like more details on the setup in Workato!