Happy Business Starts Here

Tutor

Revenue Schedule Item Invoice Item REST/SOAP extraction

I would like to extract data from the Revenue Schedule Item Invoice Item Data Source with SOAP/REST (either is fine), but I am unable to find a way to query it.

Is there a way to get the ZOQL object name for this?

 

Thank you

2 REPLIES 2
Zuora Alumni

Re: Revenue Schedule Item Invoice Item REST/SOAP extraction

Hi @PeterRing

 

Those objects are available as Datasources and are listed here in our Knowledge Base

 

It sounds like you are interested in the Revenue Event Item Invoice Item Datasource

 

These datasources are available via Export calls

 

What tool/language are you using to make your api calls?

 



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

Highlighted
Master

Re: Revenue Schedule Item Invoice Item REST/SOAP extraction

Export the data source from the UI, then transform the CSV column names.

 

The exported filename is the data source name (RevenueScheduleItemInvoiceItem.csv).

 

The column names look like this:

 

 

 

Revenue Schedule Item Invoice Item: Amount
Revenue Schedule Item Invoice Item: Created By ID
Revenue Schedule Item Invoice Item: Created Date
Revenue Schedule Item Invoice Item: Currency
Revenue Schedule Item Invoice Item: ID
Revenue Schedule Item Invoice Item: Updated By ID
Revenue Schedule Item Invoice Item: Updated Date

 

Replace colons with periods, and remove spaces.

The following query is valid:

 

 

select RevenueScheduleItemInvoiceItem.Amount, RevenueScheduleItemInvoiceItem.CreatedByID, RevenueScheduleItemInvoiceItem.CreatedDate, RevenueScheduleItemInvoiceItem.Currency, RevenueScheduleItemInvoiceItem.ID, RevenueScheduleItemInvoiceItem.UpdatedByID, RevenueScheduleItemInvoiceItem.UpdatedDate from RevenueScheduleItemInvoiceItem where createddate >= '2017-03-03';