Community - About Yong

Yong · ‎09-02-2020

Thanks for the suggestion @salmdo! Some special characters such as ./ cannot be used in the account name. The application will give the message " Account name can not contain relative path pattern like './'". Is it possible to share the special characters that sfdc does not support? A list or link might help in this case.

Yong · ‎09-01-2020

How to check payment transaction log to know why a payment failed Take the below payment for example, it failed with error 114 -- Missing Card Holder Account Data Go to Data Source Export, select the object Payment Transaction Log, adding fields and filters, such as request string, response string, payment number. If the error is returned from the payment gateway, you can bring the request and response string to the payment gateway for further clarification. Reference article https://knowledgecenter.zuora.com/Billing/Reporting/D_Data_Sources_and_Exports/C_Data_Source_Reference/Payment_Transaction_Log_Data_Source

Yong · ‎08-26-2020

Issue Description: If the Generate Billing Documents API request can't complete and return a response within 2 minutes, a 504 Gateway Timeout Response will be given. This issue usually happens when the generated billing documents have hundreds of invoice items or credit memo items, or has hundreds of usages recorders which need to be processed in the related billing documents. API reference https://www.zuora.com/developer/api-reference/#operation/POST_GenerateBillingDocuments In the backend, the API request is still being processed and may generate the billing documents successfully. Before the issue is fixed, here are two workarounds. Option 1: If the subscription contains a large number of rate plan charges or customer account has a large number of usage records, it is recommended to use Bill Run to generate big billing documents combined with GET call, such as https://www.zuora.com/developer/api-reference/#operation/GET_BillingDocuments to know which billing documents have been created. Option 2: If you are migrating data from a third party system to Zuora, when generating the billing document for the first time, either use bill run, or specify a shorter billing document generation period to control the single billing document size and generate multiple billing documents one by one. Status: Our Product and Engineering team are still working on this issue. We cannot provide an ETA of the fix yet. Tracking Number: INV-2957 Feel free to reach out to Zuora Global Support to check the latest status. https://support.zuora.com/

Yong · ‎08-24-2020

We're trying to deprecate this feature. It was originally designed for performance improvement, but that's no longer necessary.

Yong · ‎08-12-2020

How we can apply a Discount Rate Plan Charge to a specific Rate Plan Charge within a Rate Plan? If you are using SOAP call, you can use https://knowledgecenter.zuora.com/Central_Platform/API/G_SOAP_API/E1_SOAP_API_Object_Reference/ProductRatePlanCharge ProductDiscountApplyDetail is supported by API version 85.0+; (Suggested) For REST call, you can use /v1/action/update https://www.zuora.com/developer/api-reference/#operation/Action_POSTupdate After including X-Zuora-WSDL-Version: 85 in the header, you will be able to get the discount product rate plan charge updated successfully. Here is a sample code. curl --location --request POST 'https://rest.zuora.com/v1/action/update?rejectUnknownFields=true' \ --header 'X-Zuora-WSDL-Version: 85' \ --header 'Authorization: Basic xxxx' \ --header 'Content-Type: application/json' \ --data-raw '{ "objects": [ { "Id":"2c93db8173232ae9017328a119c076d0", "ProductDiscountApplyDetailData": { "ProductDiscountApplyDetail": [ { "AppliedProductRatePlanChargeId": "2c93db8373232bbc017328677a3d7c74" } ] } } ], "type":"ProductRatePlanCharge" }'

Yong · ‎08-12-2020

You are right. "If you are using WSDL 69 or later, the output from dateTime fields will be a dateTime and the output from date fields will be a date." https://knowledgecenter.zuora.com/Central_Platform/Query/Export_ZOQL/G_Dates_and_Datetimes Could you confirm are you using SOAP or REST? WSDL 69 was released in 2017. If you are using REST, dateTime is a date and is not related to timezone. Remember when you generate an invoice, the input value is a date too, invoice date and target date. When you run the bill run does not affect the generated invoice. https://www.zuora.com/developer/api-reference/#operation/PUT_BatchUpdateInvoices If you have more questions, feel free to reach out to Zuora Global Support via https://support.zuora.com

Yong · ‎08-11-2020

Hi @has77a, Invoice Due Date can be found in UI and it's a date. Here is the sample invoice from my sandbox. This customer account uses Payment Term "End of next month", so the invoice date is 6/1 and due date is 7/31. This article might help too https://knowledgecenter.zuora.com/Billing/Billing_and_Payments/IA_Invoices/Update_invoice_dates

Yong · ‎08-06-2020

We plan to perform a 360+ Sync service maintenance operation in our US and EU production environments on August 14 between 7:00 PM - 8:00 PM PDT. This maintenance is necessary as we need to upgrade our 360+ Sync database availability zone settings. During the maintenance window, US and EU production tenants 360+ Sync service will experience sync latency for approximately 1 hour. Any Zuora objects modified during this time will be synced automatically after we resume operation. This announcement will be updated when there is new progress of the scheduled maintenance. Related article https://knowledgecenter.zuora.com/CPQ/E_Zuora_360/X_Data_Connect_Overview https://knowledgecenter.zuora.com/BB_Introducing_Z_Business/Zuora_Data_Centers

Yong · ‎08-03-2020

According to our internal system, ACS-3636 is in closed status. Could you create a support ticket via https://support.zuora.com/ with your tenant id and use case so we can assist you further? Thanks.

Yong · ‎07-30-2020

Hello @deneroydon, Data Query https://www.zuora.com/developer/api-reference/#tag/Data-Queries and Action Query https://www.zuora.com/developer/api-reference/#operation/Action_POSTquery might help.

Yong · ‎07-20-2020

Why the country Vietnam is not recognized but Viet nam? We already have a community idea "Currently, Zuora only supports the country name Viet Nam. It would be great if we also supported Vietnam since both spellings are commonly used." https://community.zuora.com/t5/Zuora-Platform/Vietnam-Country-Name/idi-p/10993 Zuora follows the ISO standard in using "Viet Nam" instead of Vietnam. If you see the below ISO Website, it shows "Viet Nam" as an officially assigned entry. https://www.iso.org/obp/ui/#iso:code:3166:VN Reference https://knowledgecenter.zuora.com/BB_Introducing_Z_Business/D_Country%2C_State%2C_and_Province_Codes/A_Country_Names_and_Their_ISO_Codes If we make changes to our platform it can potentially cause issues for all customers already using the Viet Nam spelling. If you have a similar request, please vote in the above Idea.

Yong · ‎07-01-2020

If your bill run has been in Post in Progress for a long time and you would like to confirm the bill run is still running in the backned and is posting draft invoices, you can use Data Source Export to know how many draft invoices are remaining to be posted. Choose object Invoice and filter Invoice: (Invoice.SourceId = 'BR-00001321' and Invoice.Status = 'Draft') The remaining draft invoice number is 31912 in this case. If you execute this export a few seconds later, the number should decrease until it is 0. If the remaining draft invoice number has not been updated for minutes and the bill run is in Post in Progress, reach out to Zuora Global Support team via https://support.zuora.com to get further assistance.

Yong · ‎06-29-2020

I'm afraid both AQuA and Data Query are async, so you can only get the result in csv format based on the current design. The sync query can get the result in json, but it doesn't support export deleted records. https://www.zuora.com/developer/api-reference/#operation/Action_POSTquery

Yong · ‎06-28-2020

Zuora stores this result as a csv file and can be downloaded programmatically using this API https://www.zuora.com/developer/api-reference/#operation/GET_Files AQuA result csv files older than 72 hours are automatically purged from the system. https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/BE_AQuA_Job_Finder

Yong · ‎06-28-2020

This post might help most likely. https://community.zuora.com/t5/API/How-to-export-the-deleted-data-using-AQuA-API/m-p/33181 It's suggested to use stateless AQuA queries to extract the deleted data. If you would like to use stateful, you need a partner id and " Must be set to version 1.1 to export deleted data. " Sample stateful AQuA requests can be found in https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/BA_Stateless_and_Stateful_Modes

Yong · ‎06-23-2020

Data Query becomes general availability early this year, so not a lot of customers are using it. Besides the articles in the knowledge center, maybe you can reach out to your Zuora account manager or Zuora customer success manager to learn more about the a dvantage of using Data query over Aqua API (ZOQLExport). Based on the current definition in the developer center, the target value must be S3 only and there are no other options yet. https://www.zuora.com/developer/api-reference/#operation/POST_DataQueryJob The Available Tables of data query can be found in https://knowledgecenter.zuora.com/Central_Platform/Query/Data_Query/BA_SQL_Queries_in_Data_Query#Supported_SQL_Syntax Data Source objects can be found in https://knowledgecenter.zuora.com/Billing/Reporting_and_Analytics/D_Data_Sources_and_Exports/AB_Data_Source_Availability "The main difference between tables in Data Query and data sources is that tables in Data Query are not pre-joined to other tables. When you query a table in Data Query, you can arbitrarily join other tables to retrieve any data that you require. In the corresponding data source, Zuora has pre-joined the base object to a fixed set of related object types; you cannot retrieve data from other object types." Both the ZOQLExport & Data Query are asynchronous method and you need to perform multiple steps to get the result file.

Yong · ‎06-18-2020

I understand there are several knowledge center articles related to this topic and could cause confusion. Let me explain. 1. Deleted records can be extracted through Zuora AQuA API. From this article, the deleted record can be retrieved by Data Query too. Data Query is a newly released feature. https://knowledgecenter.zuora.com/Central_Platform/Workflow/Workflow_tasks/AC_data_query 2. Export ZOQL can be used to get the deleted records. ZOQL cannot return deleted records. 3. Zuora REST API supports ExportZOQL queries. Check this https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/Bulk_data__extraction_from_Zuora_using_AQuA#Extract_deleted_data_in_each_query

Yong · ‎06-17-2020

That's right. As far as I know, all the deletes that happens within the Zuora system are soft deletes. In order to comply with GDPR, there are two APIs to scrub personal information. After scrubbing, delete those records and there will be no personal data in the system. Scrub payment method https://www.zuora.com/developer/api-reference/#operation/PUT_ScrubPaymentMethods Scrub contact https://www.zuora.com/developer/api-reference/#operation/PUT_ScrubContact

Yong · ‎06-17-2020

@sundar9987 Could you be more specific on what is a rsd file? Is it a file format defined by matillion? I found this https://documentation.matillion.com/docs/2948711 My apologies I've never used this application before. Maybe reach out to matillion support and they might have some sample red file.

Yong · ‎06-11-2020

The scheduled maintenance in US Sandbox environment has compeleted.

Yong · ‎06-11-2020

The following API objects do not support the exporting of deleted records: PaymentTransactionLog RefundTransactionLog RevenueScheduleItemInvoiceItemAdjustment AccountingCode AccountingPeriod https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/B_Submit_Query/a_Export_Deleted_Data This might help too. https://community.zuora.com/t5/API/How-to-export-the-deleted-data-using-AQuA-API/m-p/33181 Using AQuA stateless queries to extract the deleted data is the suggested method.

Yong · ‎05-27-2020

We plan to perform scheduled maintenance with downtime in PCE (Production Copy Environment) on Wednesday, June 3, from 6:00 PM to 8:00 PM PDT. EPCE (Enhanced Production Copy Environment) is in this maintenance scope. The base URL of the endpoints is https://servicesxxx.zuora.com/ During this maintenance window, Production Copy Environment will be unavailable. There will be No impact to Zuora Production or Sandbox environments. This announcement will be updated when there is new progress of the scheduled maintenance. For any questions, please contact Zuora Global Support https://support.zuora.com/ Related articles: https://knowledgecenter.zuora.com/BB_Introducing_Z_Business/D_Zuora_Environments https://community.zuora.com/t5/API/REST-endpoint-base-URL-of-Production-Copy-Service-Environment/td-p/29611

Yong · ‎05-26-2020

The scheduled maintenance has completed on time. All systems are operational.

Yong · ‎05-26-2020

The scheduled maintenance has started on time.

Yong · ‎05-20-2020

Updated on 5/21 - We will be performing maintenance of our network load balancers in EU and NA Production environment (https://eu.zuora.com and https://na.zuora.com) on Tuesday, June 2, 2020 from 7:00 PM TO 9:00 PM PDT. During the maintenance window, there should be no to minimal service disruptions . If you meet any issue, please contact Zuora Global Support via http://support.zuora.com This announcement will be updated when there is new progress of the scheduled maintenance.

Yong · ‎05-20-2020

Updated on 5/21 - We will be performing maintenance of our network load balancers in EU and NA Sandbox environment (https://sandbox.eu.zuora.com and https://sandbox.na.zuora.com) on Tuesday, May 26, 2020 from 7:00 PM to 9:00 PM PDT 6:00 PM to 8:00 PM PDT. During the maintenance window, there should not be service disruptions. If you meet any issue, please contact Zuora Global Support via http://support.zuora.com This announcement will be updated when there is new progress of the scheduled maintenance.

Yong · ‎05-20-2020

The scheduled maintenance in US Sandbox environment has been finished.

Yong · ‎05-17-2020

If my understanding is correct, this feature request is the same as this one https://community.zuora.com/t5/Admin-Settings-Ideas/Expired-Session-not-redirecting-to-the-SSO-logout-page/idi-p/25261which has been released in Oct 2018 via Zuora internal engineering ticket "APG-1446 When session times out and authentication was SSO, send user to SAML logout URL". Please make sure you have set Zuora logout URL. This is a backend setting and is invisible to you. You can test by clicking logout button in Zuora UI and see if you are redirected to the expected logout URL. If not, you can request to update the logout URL by submiting a new support ticket via http://support.zuora.com/ Related articles: https://knowledgecenter.zuora.com/Central_Platform/API/G_SOAP_API/Coding_Overview/D_Sessions https://knowledgecenter.zuora.com/Billing/Tenant_Management/A_Administrator_Settings/Configure_Single_Sign-On_for_Zuora

Yong · ‎05-12-2020

How to export deleted data using AQuA API? Option 1: You can use AQuA stateless queries to extract the deleted data. This is the suggested method. Reference https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/Bulk_data__extraction_from_Zuora_using_AQuA#Extract_deleted_data_in_each_query Option 2: If you are using stateful AQuA, you can follow https://knowledgecenter.zuora.com/Central_Platform/API/AB_Aggregate_Query_API/B_Submit_Query/a_Export_Deleted_Data

Yong · ‎05-10-2020

Known Issue Payments and Invoices UI search result is wrong when clicking the search button quickly. Refer to the screen recording for more information. Based on our test, the issue will happen when click the search button more than 3 or 4 times per second. Status Zuora Engineering Team is currently working to fix this issue. No ETA can be provided yet. Reference Number INV-1782 Workaround Do not click the search button more than 3 times per second in UI.

Happy Business Starts Here