Check out this trigger. It has a literal Zuora ID in it. Why? This product, named "test", was created in Zuora, and deleted. You can't find it in Zuora either through the UI or through a query or export. But it still exists, and zuora 360 still tries to sync it to SFDC. It throws an error because Product2.DurationDays__c is a required field. I had to add this kludgey stuff to my trigger in order to prevent the Zuora Product sync from reporting an error every time.   I can't make the product actually go away, and I can't edit the Zuora_Duration_Days__c field in Zuora. The only way I could figure out to suppress the sync error is this kludge in the SFDC trigger.     // Zuora needs DurationDays__c to sync, but it cannot sync to a number field // So we sync Zuora to Product2.Zuora_Duration_Days__c and this trigger syncs that to Product2.DurationDays__c trigger ZuoraProduct2Trigger on Product2 (before insert, before update) { for (Product2 p : Trigger.new) { try { if (System.UserInfo.getName().toLowerCase().contains('zuora')) { if (p.Zuora_Duration_Days__c == Null && (p.zqu__EntityID__c == '2c92a0fd55822b48015583181b0250e6' || p.Name == 'test')) { // test product, deleted in zuora, but still gets synced p.DurationDays__c = 0; } else { p.DurationDays__c = Integer.valueOf(p.Zuora_Duration_Days__c); } } else { p.Zuora_Duration_Days__c = String.valueOf(p.DurationDays__c); } } catch (Exception e) { p.addError(String.format('Product "{0}" "{1}" error converting Zuora Duration Days "{2}"', new List<String>{p.Name, p.zqu__EntityID__c, e.getMessage()})); } } }   ... View more

Who wants to use Pandas data analysis library with Zuora in a Jupyter notebook?   We do!   Have a look: https://github.com/bolaurent/Pandas-for-Zuora   http://pandas.pydata.org/ https://www.datacamp.com/community/tutorials/tutorial-jupyter-notebook#gs.wh0bgFE   This is a *great* way to interactively explore your data. ... View more

A script that has been working for months, and has not been changed, today failed (intermittently) with the following error messages:   Authentication error Failed to get user info   Below is the output. This was in apisandbox.   One of the errors seems to be undocumented ("Failed to get user info"). I don't understand how either of them should be intermittent.   Insights?     Bo-MBP: migrate % ./reset.sh deleting accounts... Traceback (most recent call last):#### | File "./deleteaccounts.py", line 163, in <module> main() File "./deleteaccounts.py", line 158, in main deleteMigratedAccounts(zuora) File "./deleteaccounts.py", line 93, in deleteMigratedAccounts deleteAccounts(zuora, firstBatch) File "./deleteaccounts.py", line 108, in deleteAccounts results = zuora.delete('Account', chunk) File "../rest/zuora.py", line 96, in delete theseResults = self._post('/action/delete', {'type': objectType, 'ids': chunk}) File "../rest/zuora.py", line 35, in _post return self._unpackResponse('POST', path, response) File "../rest/zuora.py", line 45, in _unpackResponse assert response.status_code == 200, '{} to {} failed: {}'.format(operation, path, response.content) AssertionError: POST to /action/delete failed: b'{"message":"Failed to get user info"}\n' Bo-MBP: migrate % ./reset.sh deleting accounts... Traceback (most recent call last):####### | File "./deleteaccounts.py", line 163, in <module> main() File "./deleteaccounts.py", line 158, in main deleteMigratedAccounts(zuora) File "./deleteaccounts.py", line 93, in deleteMigratedAccounts deleteAccounts(zuora, firstBatch) File "./deleteaccounts.py", line 108, in deleteAccounts results = zuora.delete('Account', chunk) File "../rest/zuora.py", line 96, in delete theseResults = self._post('/action/delete', {'type': objectType, 'ids': chunk}) File "../rest/zuora.py", line 35, in _post return self._unpackResponse('POST', path, response) File "../rest/zuora.py", line 45, in _unpackResponse assert response.status_code == 200, '{} to {} failed: {}'.format(operation, path, response.content) AssertionError: POST to /action/delete failed: b'{"message":"Failed to get user info"}\n' Bo-MBP: migrate % ./reset.sh deleting accounts... Traceback (most recent call last):######################### | File "./deleteaccounts.py", line 163, in <module> main() File "./deleteaccounts.py", line 158, in main deleteMigratedAccounts(zuora) File "./deleteaccounts.py", line 93, in deleteMigratedAccounts deleteAccounts(zuora, firstBatch) File "./deleteaccounts.py", line 108, in deleteAccounts results = zuora.delete('Account', chunk) File "../rest/zuora.py", line 96, in delete theseResults = self._post('/action/delete', {'type': objectType, 'ids': chunk}) File "../rest/zuora.py", line 35, in _post return self._unpackResponse('POST', path, response) File "../rest/zuora.py", line 45, in _unpackResponse assert response.status_code == 200, '{} to {} failed: {}'.format(operation, path, response.content) AssertionError: POST to /action/delete failed: b'{"message":"Authentication error"}\n' Bo-MBP: migrate % ./reset.sh deleting accounts... 100% |#########################################################################| Traceback (most recent call last): File "./deleteaccounts.py", line 163, in <module> main() File "./deleteaccounts.py", line 158, in main deleteMigratedAccounts(zuora) File "./deleteaccounts.py", line 95, in deleteMigratedAccounts secondBatch = getAllAccountIds(zuora) File "./deleteaccounts.py", line 74, in getAllAccountIds result = zuora.query(ACCOUNTS_QUERY) File "../rest/zuora.py", line 52, in query response = self._post("/action/query", {"queryString" : queryString}) File "../rest/zuora.py", line 35, in _post return self._unpackResponse('POST', path, response) File "../rest/zuora.py", line 45, in _unpackResponse assert response.status_code == 200, '{} to {} failed: {}'.format(operation, path, response.content) AssertionError: POST to /action/query failed: b'{"message":"Authentication error Bo-MBP: migrate % ./reset.sh deleting accounts... 100% |#########################################################################| deleted 3 accounts classifying opps...       ... View more

I've just published the scripts that I used to load my Accounts and Subscriptions into Zuora from CSV data.   See https://github.com/bolaurent/zuora_loader   Note that these scripts are very rough; I wrote them to get my migration done, and I won't be maintaining them. I'm publishing them in case they might be of use to someone.     ... View more

I have discovered that a product I had deleted in Zuora was still being synced to SFDC. This caused a problem, because the product failed a custom validation rule in SFDC ,which caused the Zuora product catalog sync to fail. But the Zuora ID reported in the error file could not be located, either in the Zuora UI or via API. Because the record could not be viewed or edited, it could not be made to pass the custom validation rule in SFDC, and thus the sync error could not be resolved.   There seems to be no documentation of the fact that deleted records remain in Zuora and are synced. At a minimum, this should be documented.  ... View more

Oauth has only limited support in Zuora.  I would really like to have my script that accesses Zuora via API authenticate using OAUTH.   Pretty please, can we have this? Also, perhaps there should be an ideas forum for API? ... View more

This KC article says that I can contact support and get some sample code for Platform Extension. I contacted support, and was told that Platform Extensions are no longer supported, and I was not given the code.   That KC page needs to be fixed or dropped.   Also, there should perhaps be an Ideas forum for documentation? ... View more

@Richard gave a session today at subscribed, and was working with CSV files. He mentioned a tool named TAD, which turns out to be fantastically useful. It's open source; download it for free.    You can display csv files, easily choose which colums to display, in which order, filter, and pivot.     ... View more

I frequently need the link to a report. For instance, I am working with a colleague, in real time, and we are discussing the colleague's reporting need in an instant messaging system. I create a report, save it, and I want to just paste the link to the report into the IM system so that my colleague can have a look and see if the report does what she asked for.   Apparently, the only way to get the link is to schedule the report, email it to myself, fetch my email, and get the link there.    Please, just let me have the link while I am editing the report.   @Deepak_K ... View more

There's no constraint for report names saved in Zuora to be unique. But when you search for a report, and there are multiple reports with the same name, there's no way to differentiate them. This seems a recipe for a mess.   @Deepak_K   ... View more