cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Zuora

When using the native Zuora integration, more than 50% of the imported dates are "NULL".

Example: Rate Plan Charge Effective Start Date is "NULL" in about 3000 objects. (We have about 4500 subscriptions)

In the original data (observable through the zuora UI) "NULL" does not occur as a value for these dates.

I am thus unable to filter the data the way I need.

 

Screenshot

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
New Member

Re: Zuora

FYI: I solved this by creating a new API User in Zuora with US Locale and using this user for the integration.

View solution in original post

2 REPLIES 2
Highlighted
New Member

Re: Zuora

Looks like the dates get imported with day and month mixed up, resulting in all the dates with day > 12 becoming "NULL". And all the dates are wrong, of course.

How can I fix this?

Highlighted
New Member

Re: Zuora

FYI: I solved this by creating a new API User in Zuora with US Locale and using this user for the integration.

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors