Happy Business Starts Here

RestAPI Invoice.dueDate timezone

Highlighted
Student

RestAPI Invoice.dueDate timezone

Hi, I can not find any clear information about date field timezone. Is it UTC or tenant timezone? There are some artciles there about date and datetime fields but they are about soap wsdl. In my use case I am using rest api and I need to know Invoice.dueDate timezone.

3 REPLIES 3
Highlighted
Support SME

Re: RestAPI Invoice.dueDate timezone

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

 

INV00000371_-_Invoices_-_Billing_-_Zuora_Billing.png

Highlighted
Student

Re: RestAPI Invoice.dueDate timezone

Yes dueDate it is a Date but I need to know date timezone because some of my scripts depends on "end of due date". Looks like it is in UTC but in some of zuora`s resources say that dueDate in tenants timezone

Highlighted
Support SME

Re: RestAPI Invoice.dueDate timezone

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

Screen Shot 2020-08-13 at 8.28.17 AM.png