Workato | Systematic Community

Resolved! Random FIELD_INTEGRITY_EXCEPTION error that sometimes occurs but other times works

usually, we have a specific Pricebook in SFDC to link up to an order and each pricebook only has 1 Currency,but on occasion there are multiple price books in Epicor so in SFDC I would use the Standard price book and when I create the opportunity I wo...

Data Transformation Using Workato JS Connector

i created a recipe for data transformation using JS snippet by workato, in this recipe i have a group of JSON object and i'm doing data transformation like converting firstName, lastName etc to - (based on requirement) using JS code.(in this recipe...

Invalid Reference Error

I am trying to create a customer in netsuite from salesforce. There is a field called as parent. I am getting the below error i am not understanding why does is it say parent reference 0. What does this error mean?The error while creationThe field t...

Resolved! Data transformation using Javascript Connector

Hi all,I'm currently trying to do some data transformation using the Javascript connector but I can't figure out how to corrrectly configure the output. I'm trying to format a JSON body for a HTTP request to the Slack chat.scduleMessage endpoint.In ...

Resolved! Which workato connector is most capable for Database

Luckily I have autonomy to choose a database (AWS RDS based) - which connector has most wide connection+action capabilities (particularly for bulk ops)I am inclined towards Aurora (so choice between MySQL or Postgres)

Resolved! parsing salesforce report analytics api results

i have created a custom action in the SF connector to read a salesforce reportthe report data is contained in an array called datacells inside an array called rowsi have put the response body view and the raw json belowwhat is the easiest way for me ...

Resolved! Azure Data Lake

Hello,What connector do we use to connect to Azure Data Lake. Would it be the same as Azure Blob Storage?https://docs.workato.com/connectors/azure_blob_storage.html#create-your-workato-connectionWhat are the limitations when connecting to the Azure D...

Resolved! Active Directory- Create User Password

Hello automation Pros!I am working on a recipe that creates users in Active Directory using Windows Server.I am trying to map Password but I can't find the field to map it.According to AD Docs the field should be: userPasswordSearching by Passw... i...

Use formula in lookup tables

Hello everyoneI have a question about the lookup tables。I want use formula in column。I want to find a data start with “B”, How to write the formula in column?

How to use except formula in the nested object ?

I have an array which look like this below. I can manage to remove the 1st level of fields using except formula.users[0].except(:two_factor_auth_enabled,:signature).I am trying to remove the nested object field using the below formula.users[0].except...