Happy Business Starts Here

AQUA and ZOQL returns different column names

Highlighted
Zuora Support

AQUA and ZOQL returns different column names

User created custom field Auto Renew with API name AutoRenew__c, Since we already have a standard field Auto Renew in subscription AQUA results has Duplicate column names

Question: Why the AQUA report is not displaying columns with API name while Zoql report doeszuora.png

 

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Zuora Support

Re: AQUA and ZOQL returns different column names

We observe difference in custom field column name behaviour between AQUA and ZOQL as mentioned in the example below

Example

Describe call - /apps/api/describe/subscription

<name>AutoRenew__c</name>
<label>Auto Renew 1</label>

 

please find the test results below

 

Test Query - SELECT AutoRenew, AutoRenew__c, Account.Id, BillToContact.Id, DefaultPaymentMethod.Id, ParentAccount.Id, SoldToContact.Id, SubscriptionVersionAmendment.Id FROM Subscription

 

ZOQL Response

 

Zoql.JPG

 

 

 

 

 

AQUA Response

 

 

 AQUA.JPG

 

 

ZOQL export returns the column name directly from the describe call <name>

Whereas both Stateful and Stateless AQUA mode returns the column name available in <label>

Note: If the report is exported through Data source it will return the column name available in <label>

View solution in original post

1 REPLY 1
Highlighted
Zuora Support

Re: AQUA and ZOQL returns different column names

We observe difference in custom field column name behaviour between AQUA and ZOQL as mentioned in the example below

Example

Describe call - /apps/api/describe/subscription

<name>AutoRenew__c</name>
<label>Auto Renew 1</label>

 

please find the test results below

 

Test Query - SELECT AutoRenew, AutoRenew__c, Account.Id, BillToContact.Id, DefaultPaymentMethod.Id, ParentAccount.Id, SoldToContact.Id, SubscriptionVersionAmendment.Id FROM Subscription

 

ZOQL Response

 

Zoql.JPG

 

 

 

 

 

AQUA Response

 

 

 AQUA.JPG

 

 

ZOQL export returns the column name directly from the describe call <name>

Whereas both Stateful and Stateless AQUA mode returns the column name available in <label>

Note: If the report is exported through Data source it will return the column name available in <label>

View solution in original post