Happy Business Starts Here

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Highlighted
New Student

ZOQL dangling objects - TransferredToAccounting field not query-able.

I'm using ZOQL to query the Payments object, and the data is returned as expected except for the 'TransferredToAccounting' field.  Can someone explain what's going on? 

 

Here is my ZOQL query data object: 

 

{
"queryString": `SELECT Id, AccountId, Status, TransferredToAccounting
FROM Payment
WHERE AccountId = 'some-account-id'`
}

 

Tags (1)
3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Zuora Alumni

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Hi,

 

Thanks for raising this.  This is a known issue, and we are currently working on improving the documentation for clarity.

 

In this case, if you get back no value (null) this is considered a NO

 

The docuementation is in the process of being updated and reviewed.

 

Regards,

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

Highlighted
New Student

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Thanks for clarifying.  🙂 

I also discovered that to be the case.

I'm now trying to query the Payments object by using a PaymentMethodId, but it always returns an empty response.  

 

Here is my query:  

SELECT Id, AccountId, Status, TransferredToAccounting FROM Payment WHERE PaymentMethodId = '2c92c0f858ddbc340158e05ef09c2d79'

Any help is appreciated, thanks!

View solution in original post

Highlighted
Support SME

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Hello @dan-ps I have just used a very similar query, so I have adjusted it to look exactly like yours, and can confirm your query syntax is correct and should work. Can you doublecheck if the PaymentMethodId is correct?

 

SELECT Id, AccountId, Status, TransferredToAccounting FROM Payment where paymentmethodid='2c92c0f85432ded501543900e7716ab0'

         <ns1:result>
            <ns1:done>true</ns1:done>
            <ns1:queryLocator xsi:nil="1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
            <ns1:records xsi:type="ns2:Payment" xmlns:ns2="http://object.api.zuora.com/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
               <ns2:Id>2c92c085552e530301552ecf8b4726df</ns2:Id>
               <ns2:AccountId>2c92c0f85432df360154390089232ad2</ns2:AccountId>
               <ns2:Status>Processed</ns2:Status>
            </ns1:records>
            <ns1:size>1</ns1:size>
         </ns1:result>


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

5 REPLIES 5
Highlighted
Zuora Alumni

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Hi,

 

Thanks for raising this.  This is a known issue, and we are currently working on improving the documentation for clarity.

 

In this case, if you get back no value (null) this is considered a NO

 

The docuementation is in the process of being updated and reviewed.

 

Regards,

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

Highlighted
New Student

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Thanks for clarifying.  🙂 

I also discovered that to be the case.

I'm now trying to query the Payments object by using a PaymentMethodId, but it always returns an empty response.  

 

Here is my query:  

SELECT Id, AccountId, Status, TransferredToAccounting FROM Payment WHERE PaymentMethodId = '2c92c0f858ddbc340158e05ef09c2d79'

Any help is appreciated, thanks!

View solution in original post

Highlighted
Support SME

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Hello @dan-ps I have just used a very similar query, so I have adjusted it to look exactly like yours, and can confirm your query syntax is correct and should work. Can you doublecheck if the PaymentMethodId is correct?

 

SELECT Id, AccountId, Status, TransferredToAccounting FROM Payment where paymentmethodid='2c92c0f85432ded501543900e7716ab0'

         <ns1:result>
            <ns1:done>true</ns1:done>
            <ns1:queryLocator xsi:nil="1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
            <ns1:records xsi:type="ns2:Payment" xmlns:ns2="http://object.api.zuora.com/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
               <ns2:Id>2c92c085552e530301552ecf8b4726df</ns2:Id>
               <ns2:AccountId>2c92c0f85432df360154390089232ad2</ns2:AccountId>
               <ns2:Status>Processed</ns2:Status>
            </ns1:records>
            <ns1:size>1</ns1:size>
         </ns1:result>


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

New Student

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Thanks Viktor, 

 

I think I was just coding without coffee. 😉    I had deleted the original payment method, and added new ones.  Things seem to be working as expected today. 

Highlighted
Support SME

Re: ZOQL dangling objects - TransferredToAccounting field not query-able.

Glad to hear it works! 🙂



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √