Sun May 29, 2022 11:46 am
Login Register Lost Password? Contact Us

Roxie Batch Calls

Questions around writing code and queries

Wed Dec 04, 2019 9:03 pm Change Time Zone


I would like to know if it is possible to perform a call to a Roxie Query, but instead of performing a single call, I would like to run a call with several entries and get the response of all them.
For example, suppose I have a roxie that returns to me the street name. The input would be the zip code. Suppose I have a list with 5 thousand zipcodes. How could I call this roxie to return this list on single input and not doing it sequentially?

Thanks in advance.

Artur Baruchi
Posts: 19
Joined: Thu Apr 18, 2019 4:50 pm

Fri Dec 06, 2019 9:23 pm Change Time Zone


I found in documentation (pg 65 and 66 of "ECL Programmers Guide") how to do it using SOAPCALL. Basically, you create a dataset with several "search criteria" and submit to the roxie and you receive a dataset as response with the answer for each dataset used in the request.

I think it is the way to do it, however, I need this to work as an API "call" (external system, not Thor, consuming this API and sending in a single XML several search requests). Still figuring out on how to do this part.


Posts: 19
Joined: Thu Apr 18, 2019 4:50 pm

Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest