Hey all,
I am trying to make an API call in Astea to retrieve all items that match a certain criteria. I can currently get 1 item to be retrieved sucessfully, but not all items. Ideally, I would like to get my information from the top level of Installed Items so that I can retrieve other data in a single call.
The current call I am making which gets me a single item returned in the results:
<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
<session email="" alias="">
<state bc_name="item_installed">
<action name="getdescrtable">
<attribute table_name="item_inst" key_name="ce_pref_comm" key_value="E" element_name="ce_email_id" default_value=""/>
</action>
</state>
</session>
</root>
Ideally I would like to call something like:
<root xmlns:dt="urn:schemas-microsoft-com:datatypes">
<session email="" alias="">
<state bc_name="item_installed">
<action name="export">
<attribute bo_name="main" key_name="ce_pref_comm" key_value="E" columns="item_id,serial_no,tagno,ce_pref_comm,ce_email_id,cc_cconth_id"/>
</action>
</state>
</session>
</root>
I have had a look at the ‘ExecQueryNoLimit’ action, but I am struggling to figure out the ‘query_name’ I should use.
I can make multiple other calls without issue, so this is more around knowing exactly will call to make. I should also note that we are running a Cloud instance on version 14.0.
Any help would be greatly appreciated.
