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.
