Workato | Systematic Community

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 ...

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...

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...

Efficient API Testing: How Automation Frameworks Streamline Development

IntroductionBegin by discussing the increasing complexity of modern software development and how APIs are integral to system communication. Highlight the need for efficient API testing to ensure smooth integration and performance across services.Acce...

Subscriptions in GraphQL Connector

Is it technically possible to implement GraphQL Subscriptions in a custom connector? If so, are there any documentation or hints?There is an official GraphQL Connector from Workato. In its announcement link it states that it doesn't support GraphQL S...

use formula in lookup entry field

Hello marlon-muela I want to ask a question about the [Lookup entry ] Can I use formula in [Lookup entry ]'s lookup by field?

A lot of woakto API Endpoints in Workato Developer API is not working

I am trying to create an export package for my folder through workato Developer API Endpoint. But getting below error. Appreciate any kind of help in resolving this error. 500 Internal Server Error { "message": "Server error", "id": "ef0fe5eb-c909-46...

CSV Formatting Challenge

Hey all - I need to compose a CSV in Workato that I am not sure is possible, here is my criteria (screenshot below): Row 1 has to be as follows: EmployeeManagerImport,,,,,,Row 2 has to be as follows: H,EmployeeManager,EmployeeManager,EmployeeXRefCod...