topic Mailchimp API Connector Error in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Mailchimp-API-Connector-Error/m-p/2458347#M20722 <P>Hi,&nbsp;</P> <P>I'm trying to bring in data from Mailchimp but when I connect the API it tells me "<SPAN>(Connector error: String </SPAN><SPAN>'-001-11-30T00:00:00+00:00'</SPAN><SPAN> was </SPAN><SPAN>not</SPAN><SPAN> recognized </SPAN><SPAN>as</SPAN><SPAN> a valid </SPAN><SPAN>DateTime</SPAN><SPAN>.)</SPAN>":</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lydang_0-1705069620025.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127010iC67E170D47D97FF5/image-size/medium?v=v2&amp;px=400" role="button" title="lydang_0-1705069620025.png" alt="lydang_0-1705069620025.png" /></span></P> <P>I know the problem is coming from "send_time" as when I take this out I have no issues.&nbsp;I have tried to exclude the string from the SELECT statement but I get another error message saying that it could not parse the SELECT statement.</P> <P>Has anyone had this issue before?</P> Fri, 31 May 2024 16:19:28 GMT lydang 2024-05-31T16:19:28Z Mailchimp API Connector Error https://community.qlik.com/t5/Integration-Extension-APIs/Mailchimp-API-Connector-Error/m-p/2458347#M20722 <P>Hi,&nbsp;</P> <P>I'm trying to bring in data from Mailchimp but when I connect the API it tells me "<SPAN>(Connector error: String </SPAN><SPAN>'-001-11-30T00:00:00+00:00'</SPAN><SPAN> was </SPAN><SPAN>not</SPAN><SPAN> recognized </SPAN><SPAN>as</SPAN><SPAN> a valid </SPAN><SPAN>DateTime</SPAN><SPAN>.)</SPAN>":</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lydang_0-1705069620025.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127010iC67E170D47D97FF5/image-size/medium?v=v2&amp;px=400" role="button" title="lydang_0-1705069620025.png" alt="lydang_0-1705069620025.png" /></span></P> <P>I know the problem is coming from "send_time" as when I take this out I have no issues.&nbsp;I have tried to exclude the string from the SELECT statement but I get another error message saying that it could not parse the SELECT statement.</P> <P>Has anyone had this issue before?</P> Fri, 31 May 2024 16:19:28 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Mailchimp-API-Connector-Error/m-p/2458347#M20722 lydang 2024-05-31T16:19:28Z