Compass/jobs API - Dynamic/Parameterized Query

Heya peeps

So I have finally figured ou the Compass API in the new environment, but am hoping to get some feedback on the use of a dynamic query.

I have an incoming document (json) with two items: Entity and Period, to be used as references for a query out of datalake to pull ERP data joining multiple tables.

What I can't figure out is how to pass the parameters from the inbound document as parameters to the query. The usual ALT-SPACE in the interface isn't yielding anything, and the help documentation doesn't make any mention of parameters.

Is it really down to parsing the document with Python to import the parameters, generate the script and pass the full actual query as another document input?

Find more posts tagged with

Infor Data Fabric

Accepted answers

prabodhaa

currently, we have a few datalake-based integrations that require dynamic query and we use another Python scripting component to build the query. the output of the python can be accessed in the API response body.

All comments

ben-pope

I tried to use the datalake api in this manner and did not have much luck. This was months ago, and I have since done a bit of python scripting, and think that could be an option to create your dynamic payload.

Another potential option would be to use the native datalake objects in a data flow. But I don't think that you can get parameterized queries out of the anysql data modeler, please, anyone prove me wrong on this.

Another possible approach would be if the period is always the same amount of time you could create a view in the datalake and query that.

prabodhaa

lgilroy

that's kinda what i figured; ugh, python of all things like bruh

lgilroy

Hey Prabodha - you wouldn't happen to know of any documentation that identifies the inbound content for the script. One of the example scripts from some infor KBs uses io.StringIO(bodxml_content) and given that this isn't defined anywhere I assume is the stream input for the bod...?

Copyright © 2025 Infor. All rights reserved.