I am testing the API in the sandbox and trying to create an invoice for a specific item which is in the sales inventory. However, the API requires the itemID and this is not stated in the sales inventory page. I tried using the item name but his does not work.
Any ideas please?
Hello @samppatel
Admittedly, this is hidden on the interface within QuickFile, but it is there in the HTML of the page
However, through the API, you can search or pull a specific item using the Item API
methods:
https://api.quickfile.co.uk/method/item
Or, if it’s a one off line, the value 0
should be accepted by the API.
I hope this helps.
Great. Sorted. Thank you.
1 Like
Is there a way to export the inventory including the “item ID” for each item, I need the item ID for the Invoice create api, I can run the invoice Get for individual invoices which will give me the item id for items in a single invoice, however this would take me forever to get all the item Id’s I need.
Thanks
Rob
Hi @Rob
You can run an inventory search in the sandbox and return the results from there?
https://api.quickfile.co.uk/d/v1_2/Item_Search
If you used something similar to the below, it should return all items for you (not tested):
<Item_Search xmlns="https://api.quickfile.co.uk" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://api.quickfile.co.uk https://api.quickfile.co.uk/schemas/1_2/Item_Search.xsd">
<Header>
<MessageType>Request</MessageType>
<SubmissionNumber>00000001</SubmissionNumber>
<Authentication>
<AccNumber>123456</AccNumber>
<MD5Value>7dd259dea3393880406d292e3f6f5830</MD5Value>
<ApplicationID>appID</ApplicationID>
</Authentication>
</Header>
<Body>
<SearchParameters>
<ReturnCount>10</ReturnCount>
<Offset>0</Offset>
<OrderResultsBy>ItemName</OrderResultsBy>
<OrderDirection>ASC</OrderDirection>
</SearchParameters>
</Body>
</Item_Search>
Thanks Matthew
this has worked for me, what is the return count limit? I have 600 items? how would I import all items if the limit was say 200?
Rob
200 are returned at one time, but you can use the ReturnCount
and Offset
values to move this forward.