When working with Sitecore Connect/Workato, there are times when you need to access the complete response body of a previous step or trigger as a data pill rather than just specific parameters of the response object. This is especially useful when working with integrations like OpenAI, which can automatically process JSON without requiring manual mapping of each individual parameter by system integrators.
In Recipe Editor’s Data Pill Selection pane, while you might see the Response Body of the previous step in subsequent steps, it doesn’t allow you to select the same directly.
After some trial and error, I found the workaround: switching to Formula mode!
By toggling to the formula editor, you will be able to select the full JSON body object of the previous step’s response. This simple but powerful tweak allows you to avoid time-consuming direct field mapping work, especially when working with connections like Azure OpenAI.
This tip saved me a lot of time and effort, and I hope it does the same for you!