Hello all, This will be my first post, so I apologize in advance for any rough edges in formatting and the like. The issue is that I need to load Zuora object data to a target Redshift database. There is an ETL process in place that grabs the Zuora data and loads it into Redshift. However, I am finding columns I expect to exist, as per the documentation (e.g. https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Invoice), are missing. I am aware that it seems that the SOAP API linked is not under active development, but calls to the REST API's data exports using ZOQL (e.g. "select * from invoice") seem to return a set of fields/columns that align with what is linked. Namely, in the case of objects such as Invoice and Subscription, there seems to be an AccountId field missing from the data given by Zuora. With the help of some external investigation, it seems that this column is missing because it is not denoted for export, unlike the rest of the fields on the object. Ultimately, my questions are twofold. First, can someone help me understand why it seems that AccountId is purposefully not reported as part of data exports? Secondly, the end goal of grabbing the Zuora data is to relate the objects together on the Redshift using usefuly queries, so how could one paint the picture of a given Account using all the Zuora data, if fields such as AccountId are missing, if that would even be possible? One hiccup I imaginge causing a not insignificant gap in my understanding is that I do not have credentials to explore the Zuora UI itself, I am only able to solely interpret the data received from API calls and what understanding I can formulate from written documentation online. I would greatly appreciate any insight on the matter. Thank you!
... View more