[AQuA] errorCode: 90005: "There is a syntax error in one of the queries in the AQuA input."

[Eva]

Problem:

Error while querying AmountHomeCurrency and HomeCurrency from JournalEntryItem using AQuA:

Request example:

{ 
"format" : "csv",
"version" : "1.1",
"name" : "JournalEntryItem",
"encrypted" : "none",
"useQueryLabels" : "true",
"dateTimeUtc" : "true",
"queries"  : [ { 
"name":"JournalEntryItem",
"query":"select AmountHomeCurrency and HomeCurrency from JournalEntryItem", 
"type":"zoqlexport"
} 
] 
}

Response:

{
    "errorCode": "90005",
    "message": "There is a syntax error in one of the queries in the AQuA input",
    "useLastCompletedJobQueries": false,
    "batches": [
        {
            "localizedStatus": "pending",
            "recordCount": 0,
            "full": true,
            "apiVersion": "97.0",
            "batchType": "zoqlexport",
            "status": "pending",
            "name": "JournalEntryItem",
            "query": "select AmountHomeCurrency and HomeCurrency from JournalEntryItem"
        }
    ],
    "encrypted": "none",
    "status": "error",
    "name": "JournalEntryItem",
    "offset": 0,
    "version": "1.0",
    "format": "CSV"
}

[Eva · Accepted solution]

Cause:

"Currency Conversion" feature is not enabled in the tenant, therefore HomeCurrency and AmountHomeCurrency fields are not available in journal  Entry Item object. 

https://knowledgecenter.zuora.com/CC_Finance/D_Finance_Settings/F_Foreign_Currency_Conversion

As checking from data source export against Journal Entry Item object.

• Feature disabled:

• Feature enabled:

Solution:

• Remove HomeCurrency and AmountHomeCurrency fields from the query 
• Or, if you wish to have access to this Currency Conversion feature, submit a request at Zuora Global Support.