Happy Business Starts Here

[REST] getting error "invalid value for field TransferredToAccounting: No" when querying

Highlighted
Zuora Support

[REST] getting error "invalid value for field TransferredToAccounting: No" when querying

Problem:

 

You are running into an error "invalid value for field TransferredToAccounting: No" when performing a query API call using the URL https://rest.apisandbox.zuora.com/v1/action/query  from https://www.zuora.com/developer/api-reference/#operation/Action_POSTquery

 

For example: 

 

You are running this query:

 

Query: { 
"queryString": "Select Id,InvoiceNumber,PostedDate From Invoice Where TransferredToAccounting = 'No'" 

 

In the response you are receiving:

 


"faultcode": "fns:INVALID_VALUE", 
"faultstring": "invalid value for field TransferredToAccounting: No", 
"detail": { 
"MalformedQueryFault": { 
"FaultCode": "INVALID_VALUE", 
"FaultMessage": "invalid value for field TransferredToAccounting: No" 


}

 

 

Solution

 

This has to do with permissions.

 

Currently, your Billing Role is set to Zuora Billing Standard User and that particular User Role doesn't have permission to override the Transferred to Accounting field:


You can create a custom finance user role with the permission checked and assign it to yourself. Then you can try again.

 




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