- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √