Happy Business Starts Here

Highlighted
Zuora Staff

Fields names in ZOQL export - Data Source field mapping

The data sources UI has an item  {Revenue Schedule Invoice Item: Revenue Schedule Recognition Start}

but when I pull the whole data sources I see only {RevenueScheduleInvoiceItem.RecognitionPeriodStart}

Are these two items the same?

 

In the ZOQL export query, 

When I asked for    Revenue Schedule Invoice Item: Revenue Schedule Recognition Start

I got the following error:
code: INVALID_VALUE
msg: There is no field named RevenueScheduleInvoiceItem.RevenueScheduleRecognitionStart



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: Fields names in ZOQL export - Data Source field mapping

"Revenue Schedule Recognition Start" ( on the UI ) and RecognitionPeriodStart ( with ZOQL / ZOQL export / AQuA ) return the same values. 

 

to get the fields names mapping with the Data Source you can use the REST API , describe call to get the object's fields :

 

REST API documentation :  https://www.zuora.com/developer/api-reference/#operation/GET_Describe  

 

For example : 

 

GET https://rest.apisandbox.zuora.com/v1/describe/RevenueScheduleInvoiceItem

Response :
... <field> <name>RecognitionPeriodStart</name> <label>Revenue Schedule Recognition Start</label> ...


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