Hi everyone,I have pasted a sample JSON below which is in string format. I need to do below two activities. Please suggest how to do it in Workato.1. Convert the string to JSON object.2. Iterate through the two "results" objects present inside the J...
Good day, hope all is well, I am trying to make a sum of a column in a lookup table depending on the id (right now I hard coded the id for testing purpose).I have tried many formulas but it doe not seem to work. see my pluck image. Please help I...
Hello Team,I am new to Workato, i am trying to build a data integration to sync data from Workday to SharePoint List.I have employee data coming from Workday, which is also stored in a SharePoint list. My requirement is to set up a daily integration...
We have a customer looking to use Workato to connect to RAbbitMQ. Has anyone done that? Any pointers?Thanks!
Hello everyone, I'm writing to ask if any of you have ever managed to connect a workato environment (or another ETL outside the azur environment) to a lakehouse or warehouse in the Fabric environment. It's as if the warehouse doesn't act as a SQL ser...
Hi,I am moving from my current company tietoevry to Hexaware. Please let me know how the Certifications can be transferred as my email ID will be changed Hexaware is a workato Partner. My current company isnt a partner but Hexaware (that company) tha...
I'm building a pipeline that takes contents from one system (via an API call using the HTTP connector) which is then being used to create/update an object in a different system (via the GraphQL connector issuing a mutation). The content coming from t...
Hello, I have an API call with a date filter and I want to get the information from the last 30 days. So I created a parameter like this:today-30.daysand called it "Last30days". Then I added the parameter to my API call to be like this:my_API_call_?$...
Hello,I am very new to this. But let me explain the issue I am having. I have sales Order Lines records as datapills and now I want to add the data dynamically in Send HTTP Request which I am not sure.I thought to use for each loop and put HTTP insid...
Hi All,I am trying to connect to a SFTP server using public/private key authentication. The public key is configured in the SFTP server and when I am trying to establish connectivity using Workato with private key, getting below error."could not sett...
