Connector Improvement: Zuora add User table
Completed
In every table you have created_by_id and updated_by_id. These technical ids are not very helpful. It would be great if you could add the user table to which those fields are linked. This can be done programmatically via the newer “Data Query” interface from Zuora. Here are some links with more info:
https://community.zuora.com/t5/API/Exporting-User-List-using-ZOQL/m-p/33295
https://knowledgecenter.zuora.com/Central_Platform/Query/Data_Query/A_Overview_of_Data_Query
-> User table: select * from User
https://www.zuora.com/developer/api-reference/#tag/Data-Queries
If you would be able to see and analyze the actual Zuora user who created objects you could analyze things like how many subscriptions have been created automatically vs. manually and many more interesting scenarios.
-
Official comment
Hi Dominik,
we have just implemented this - please submit a support request and we will enable it for you.
-
Thank you very much for considering this feature request. I tried it and it is already working great.
I notice that not all columns of the User table are available via your connector. I agree that all “Zuora * Role” columns are probably not that interesting for reporting. But I’d suggest to think about adding the columns “Status” and “Last Login” to the data model of your User table. Now as the general connection is there, I assume this shouldn’t be a big deal.
Please sign in to leave a comment.
Comments
2 comments