Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with OData filter on component tMicrosoftCRMInput (using v2016(odata))

Hi, 

I'm trying to use the component tMicrosoftCrmInput v2016 (odata) to import some data from a Dynamics 365 CRM, and it's working fine, but I can't prefilter data by modifiedon date, I already tried many format ... 

 

modifiedon is a Date type and using the following date format : "yyyy-MM-dd'T'HH:mm:ss'Z'"

Useful translation : Supérieur ou égal = Greater or equal 

Thank you in advance for your answer !

 

 

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Hello,

Could you please indicate which talend build version you are using? What does your actual result look like? Is it working when use "yyyy-MM-dd HH:mm:ss"?

Best regards

Sabrina

rp2018
Creator
Creator

I'm having the same issue with filtering modifiedon GreateEqual "'2018-08-20T03:56:13Z'" in tMicrosoftCrmInput component.  Does anyone have a solution for this?  

 

NOTE:  CRM is outputting the modifiedon as "yyyy-MM-dd'T'HH:mm:ss'Z'"