Using the CSV parser is really simple. Choose the Utilities app in your recipe's actions, and select the Parse CSV document. Data used by the CSV parser should be in CSV (comma separated values) format. Take this example spreadsheet:
| ID | Fruit | Color |
| 1 | Apple | Red |
| 2 | Banana | Yellow |
| 3 | Carrot | Orange |
For options two and three, Workato should be able to connect via a REST API. Most modern apps, including many of the apps supported by Workato, will have this. If the app has a developer program, it will likely have a REST API. If you are unsure, you may need to ask the app's technical experts.
Using the HTTP Connector is recommended for users who:
- Are comfortable programming with REST APIs.
- Have fewer use cases (for example, only need to sync a few kinds of records), or need to have recipes up and running as soon as possible.
Building a new app connector using Workato's Software Development Kit (SDK) makes connecting with the app much easier. Once a connector is built, users can add the new connector into a recipe just like any other app. If you would like more information, Workato representatives are available over the phone at (844) 469-6752. Alternatively, we can be contacted over chat, email, and support tickets.
Have a question? Find similar questions in our Q&A (Application) Forums or Start a New Topic.