Dave Noderer's Blog

May 2017 Entries

Get Custom Fields using Quickbooks SDK

I was attempting to get a custom field that a customer had added to Items.

It took me a while to figure out it is simple but obscure and basically just requires adding a child element of OwnerID = 0.

Once I found it, the QB SDK documentation was clear after looking at this article for getting Customer custom info:

Described here:https://developer-static.intuit.com/qbSDK-Current/doc/html/wwhelp/wwhimpl/js/html/wwhelp.htm.

One thing is that the DataExtRet element contains custom fields and only exists if that Item has data for the custom field(s) present.

Request for item query:

<?xml version="1.0" ?>
<?qbxml version="13.0"?>
- <QBXML>
-   <QBXMLMsgsRq onError="stopOnError">
      <ItemQueryRq requestID="2">
         <OwnerID>0</OwnerID>
  </ItemQueryRq>
  </QBXMLMsgsRq>
</QBXML>

Environment:
  • The customer is running Enterprise 16
  • I'm using SDK type library is QBXMLRP2 1.0 Type Library, File Version 13.0.R4000 + 10
  • The app is a WPF/C# desktop billing application.
  • Currently using  Visual Studio 2015 Enterprise.