Formatting Date - INVALID_STRING_DATE_TIME

42 views
Skip to first unread message

Andy

unread,
Nov 8, 2018, 6:43:58 PM11/8/18
to AdWords API and Google Ads API Forum
Hi, 

Trying to upload offline conversion (just one as a test, first time i am trying to mutate, usually just pulling data) - using adwords v201809 - PHP Library

I am getting an error back as follows:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body><soap:Fault>
<faultcode>soap:Client</faultcode>
<faultstring>DateError.INVALID_STRING_DATE_TIME @ ; trigger:'xxxxxxx'</faultstring>
<detail>
<message>DateError.INVALID_STRING_DATE_TIME @ ; trigger:'xxxxxxx'</message>
<ApplicationException.Type>ApiException</ApplicationException.Type>
<errors xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="DateError">
<fieldPath></fieldPath>
<trigger>xxxxxxx</trigger>
<errorString>DateError.INVALID_STRING_DATE_TIME</errorString>
<ApiError.Type>DateError</ApiError.Type>
<reason>INVALID_STRING_DATE_TIME</reason>
</errors>
</ApiExceptionFault>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>

The date I am trying to send is like this:

 20181025 060000 Europe/London

I have tried other variations, like standard yyyy-mm-dd h:i:s etc

Thanks

Andy



Luis Xander Talag (AdWords API Team)

unread,
Nov 8, 2018, 9:15:50 PM11/8/18
to AdWords API and Google Ads API Forum
Hi Andy,

Can you provide your clientCustomerId, and complete SOAP request and response logs while setting the date and time to 20181025 060000 Europe/London as it seems it's in the correct format based on this link so I can further investigate the issue on my end? You can send it to me via Reply privately to author.

Thanks,
Luis
AdWords API Team

Andy

unread,
Nov 9, 2018, 6:17:04 AM11/9/18
to AdWords API and Google Ads API Forum
Hi Luis

Please ignore previous private response, fixed it now :)

Just incase anyone else has a similar issue, it's always worth checking the correct values are being inserted correctly in your code, I was inserting the Conversion Click string in the Conversion Time field - could've kicked myself when i saw it the next day!

Thanks

Andy
Reply all
Reply to author
Forward
0 new messages