HOME / COMMUNITY Switch to knowledge base

Where do I get ItemID for a Inventory sales item

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

image

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.