Are there example Groovy Scripts of getting external SQL datasets and outputting the dataset for use
I am trying to update some data about our Assets in JDE from a SQL database using an Orchestration. Are there any example Groovy scripts that show how to take a dataset from an External SQL table and make the dataset the output of an Orchestrator Service Request?
The end goal is to be able to iterate through that dataset in other Service Requests that update Assets in JDE (like adding Latitude and Longiitude or updating the location).
Thanks.