Happy Business Starts Here

Zuora Support

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



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" 






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 √