DateTime formatting in Salesforce Output Tool

Hi all,

I am trying to import data into a DateTime field in Salesforce, but I keep getting a field type error. From what I've read on the Salesforce forums, acceptable formats for loading DateTime data include:

yyyy-mm-dd hh:mm:ss
yyyy-mm-ddThh:mm:ssZ
yyyy-mm-ddThh:mm:ss.sssZ

However, I can't seem to get it to work. If I try either of the last two formats, it seems like Alteryx reads in the numerical Excel date value instead of the formatted result, I also tried converting the file to a CSV to force the formatting, but it still gave me the same formatting error.

This is the formatted date I'm trying to pass in:

2015-09-28T21:43:36.000z

And this is the error:

Error: Salesforce Output (2): Record-level error from Salesforce API: "INVALID_FIELD:Failed to deserialize field at col 8. Due to, '42275.9052777778' is not a valid value for the type xsd:dateTime:JBCXM__ResponseDate__c --"

Anyone have a solution?

Thanks in advance for your help!

Shannon

Preparation

Accepted answers

NeilR

Hi Shannon,

Your solution is VERY close to working - you just need to capitalize the "Z". The following date should work: 2015-09-28T21:43:36.000Z

We're using the BULK API for uploading records to SFDC so the pertinent documentation is here.

That being said, the Salesforce Output tool should probably be automatically converting Alteryx dates to this format, which it is not. I will see if we can build this feature into a future version of the tool.

Neil

All comments

michael_treadwell

If I interpret your problem correctly, you are reading in a file (.xlsx or .csv) into Alteryx with a date field of the format 2015-09-28T21:43:36.000z. Then you are attempting to use the Salesforce Output tool to output the data.

If that is the case it might just be that Alteryx is reading your date column as a string because of the format. There is a DateTime Parse tool that can help in this case.

Check to see if the attached module helps. If not, it may just be that I do not fully understand your issue.

date_convert.yxmd

NeilR

Hi Shannon,

Your solution is VERY close to working - you just need to capitalize the "Z". The following date should work: 2015-09-28T21:43:36.000Z

We're using the BULK API for uploading records to SFDC so the pertinent documentation is here.

Neil

JD1607

Hi Neil,

I've just experienced a similar issue to the original poster. Your explanation makes sense but I can't seem to actually format my date like this in Alteryx in a way which will work in the Salesforce output tool.

My date field is generated in the Alteryx workflow (with a Formula tool) using ‘DateTimeFirstOfMonth()’. I’ve tried to format it in a number of different ways but I can’t get it to work and the following error message comes up on the Salesforce output tool when I run the workflow:

Record-level error from Salesforce API: "INVALID_FIELD:Failed to deserialize field at col 2. Due to, '2017-01-01 00:00:00' is not a valid value for the type

I'd really appreciate help on this!

Thanks,
James

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703