IDM Api (/infor/IDM/api/items/search?)

Hi.

does anybody know if it is possible to 'narrow down' the api-result coming from IDM?

example:

using the method '/items/search?'

$xQuery = eval("/Kundefaktura[@M3_Company = ${FN}${_CONO}${FN} AND @M3_Division = ${FN}${_DIVI}${FN} AND @M3_IVDT = ${FN}${_DATE}${FN}]");

This query gives me a list of invoices, including ALL metadata AND the base64encoded pdf files...

problem: If the number of invoices exceeds in the thousands... then the result xml/json file will be enormous.

wanted solution: possibility to 'filter' the api-result, so that I can ONLY get the metadata needed i.e. IVNO/ORNO/CUNO/CUNM/file_name/etc.

Please help! :-)

Find more posts tagged with

Hi Stig,

only /items/{pid}/resource/stream Retrieves an item's main resource file

the other api calls only show the attribute and the link to the resource.

You should use the $offset and $limit to fetch all the records in batches and then per individual item fetch the resource file when needed.

Hi Stig,

only /items/{pid}/resource/stream Retrieves an item's main resource file

the other api calls only show the attribute and the link to the resource.

You should use the $offset and $limit to fetch all the records in batches and then per individual item fetch the resource file when needed.

Thank you very much Christiaan!

but, is there a possibility to 'filter' the api-result via the xQuery? (almost like a sql-statement)

Hi Stig

I think you can use filters as below.: /M3_CustomerInvoice[@M3_InvoiceNumber="{id1}"AND@M3_InvoiceYear="{id2}"]

I'm using this in multiple occations. Assume you'd like to select @M3_Customernumber = xxx and M3_InvoiceYear = xxx

Thank you Kristoffer!

I was more thinking of 'narrow down the api-response'...

"give me ONLY the INVO and CUNO" nothing else... ;-)