Query using DTXQL to get data from Xcenter cloud
I need to pull data from XOCS cloud from table Table: trl_rtrans_lineitm_p
Following service guide , i did try with DTXQL and i get error .. any one tried or have any suggestion ?
<query xmlns:ns2="http://micros.com/xstore/config/common" xmlns:ns3="http://micros.com/xstore/config/query" name="My_Query">
<ns3:Select from="RetailTransactionLineItemProperty" distinct="true"/>
<ns3:Where>
<ns3:Required field="organizationId" parameter="argOrganizationId" />
</ns3:Where>
</query>
Error :- getObjectByQuery() exception CAUGHT on datasource Local while executing query key"