topic Problem with OData filter on component tMicrosoftCRMInput (using v2016(odata)) in Talend Studio

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

Anonymous — Mon, 21 Aug 2017 15:20:15 GMT

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 !

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

Anonymous — Mon, 28 Aug 2017 04:02:24 GMT

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

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

rp2018 — Tue, 21 Aug 2018 22:28:08 GMT

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'"