search

intacct / intacct-sdk-net

Official repository of the Sage Intacct SDK for .NET
https://developer.intacct.com/tools/sdk-net/
Apache License 2.0
31 stars 45 forks source link

readByQuery Child Object #69

Closed h-morales closed 6 years ago

h-morales commented 6 years ago

Is there anyway we can use the child objects field for readbyquery such as below?

 <readByQuery>
          <object>APPAYMENT</object>
          <query>ITEMS.RECORDID = 'TEST 101'</query>
          <fields>*</fields>
          <pagesize>10</pagesize>
          <returnFormat>xml</returnFormat>
        </readByQuery>
jimmymcpeter commented 6 years ago

Unfortunately, joins are not supported by readByQuery

h-morales commented 6 years ago

Is there a way to query APPayment using invoice number?

jimmymcpeter commented 6 years ago

I would post your question to the Developers group on the Sage Intacct Community. It's the top link on this page -- https://developer.intacct.com/support/

A few hundred people watch that group compared to the SDK GitHub issues here. The issues here are meant more for code-level assistance or bugs with the SDK itself.