Setting IsActive for Employee through qbXML

Question

I keep the following error when adding or modifying Employees with QbXml: QuickBooks found an error when parsing the provided XML text stream.

I have tried true/false (which is the values that it returned), yes/no, and 1/0; none of which seem to work.

Is it possible to set the IsActive field for employees? Am I missing something?

Thanks!

Exception thrown was:

{System.Runtime.InteropServices.COMException (0x80040400): QuickBooks found an error when parsing the provided XML text stream.
   at Interop.QBXMLRP2.IRequestProcessor4.ProcessRequest(String ticket, String inputRequest)
   at PayrolImport.Program.Main(String[] args) in Program.cs:line 251
   at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
   at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
   at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()}

XML

<?xml version="1.0"?>
<?qbxml version="12.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <EmployeeModRq>
      <EmployeeMod>
        <ListID>8000007D-1367847338</ListID>
        <EditSequence>1367850617</EditSequence>
        <FirstName>first name</FirstName>
        <MiddleName>middle name</MiddleName>
        <LastName>last name</LastName>
        <IsActive>true</IsActive>
        <Email></Email>
        <AccountNumber>1</AccountNumber>
      </EmployeeMod>
    </EmployeeModRq>
  </QBXMLMsgsRq>
</QBXML>

Post your XML request, or the code you're using to generate the XML to send to QuickBooks. — Keith Palmer Jr., May 06 '13 at 15:37

score 2 · Accepted Answer · answered May 07 '13 at 02:55

The order of XML elements in qbXML matters.

So if the QuickBooks OSR documentation shows that the order of XML elements should be this:

<ListID >IDTYPE</ListID> <!-- required -->
<EditSequence >STRTYPE</EditSequence> <!-- required -->
<IsActive >BOOLTYPE</IsActive> <!-- optional -->
... lots of other stuff here ...

And you send this:

<ListID>8000007D-1367847338</ListID>
<EditSequence>1367850617</EditSequence>
... lots of other stuff here ... 
<IsActive>true</IsActive>

Then you'll get that error back:

(0x80040400): QuickBooks found an error when parsing the provided XML text stream.

That error is essentially QuickBooks trying to tell you that you have some error in your XML document.

If you send the nodes in the correct order it will work OK:

<ListID>8000007D-1367847338</ListID>
<EditSequence>1367850617</EditSequence>
<IsActive>true</IsActive>
<FirstName>first name</FirstName>
<MiddleName>middle name</MiddleName>
<LastName>last name</LastName>

As a side note, if you use the "XML Validator" tool included with the QuickBooks SDK, it will tell you exactly what is wrong with any XML message you feed to it.

Hope that helps!

Thanks, I'll give it a shot. I discovered the order issue with another query, so that makes sense. I also discovered that if you set the SDK log INI to verbose, it gives some additional error reporting that helps in debugging. — user2354924, May 07 '13 at 10:48

Setting IsActive for Employee through qbXML

1 Answers1

Linked

Related