Happy Business Starts Here

Highlighted
Zuora Staff

EXPORT ZOQL - Howto query account level custom fields visible on the JournalEntryItem data source

We have a custom field named ‘WorkshareBillingEntity__c’ , on the account object.


In the Data Source export we observe a column "Journal Entry: Account Workshare Billing Entity" and we can't find a way to query this field using the EXPORT ZOQL on a JournalEntryItem data source

 

We’ve tried different queries with the following field name but they all supply the same error.

WorkshareBillingEntity__c
JournalEntry.WorkshareBillingEntity__c

 



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

1 REPLY 1
Zuora Staff

Re: EXPORT ZOQL - Howto query account level custom fields visible on the JournalEntryItem data so

 

The "Account Workshare Billing Entity" field you can see on the "Journal Entry" object on the JournalEntryItem Data Source is related to the Segmentation Rule you have created on your tenant using the Custom field.

 

https://apisandbox.zuora.com/apps/SegmentationRule.do?method=list

 

With the EXPORT ZOQL, you can query this field with "__s" and not "__c" at the end of the field name:
JournalEntry.AccountWorkshareBillingEntity__s



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