Resolve Amazon error for date and time mappings

Amazon doesn't send consistent date and time formats. Amazon sends date and times in two formats:

1. YYYY-MM-DDTHH:mm:ss.SSSZ
2. YYYY-MM-DDTHH:mm:ss

This results in mapping errors and failed flows as the Integration App is unable to identify and map the date and time fields.

Resolution

When the date and time formats are inconsistent, it is recommended that you configure the multi-field mapping. You'll need to use the following format. Choose whichever field you want to use as your delta date:  

{{{regexReplace PurchaseDate "Z" ".[0-9]{3}Z$"}}}
OR
{{{regexReplace LastUpdateDate "Z" ".[0-9]{3}Z$"}}}

Update the date and time mapping via flow settings:

1. Login to your integrator.io account.
2. Click Amazon - NetSuite integration app tile.
3. Go to Flows tab > Order (FBA/MFN) section.
4. Next to the appropriate order flow. click Mappings  . 
   1. For the Amazon (MFN) Order to NetSuite Order Add flow, in the Amazon (MFN) Order Import Adaptor import, next to the PurchaseDate mapping, click Settings.
   2. For the Amazon (FBA) Order to NetSuite Order Add flow, on the Edit Mapping window, select the Amazon (FBA) Order Import Adaptor import. Next to the PurchaseDate mapping, click Settings.
      
      
5. Edit the PurchaseDate mapping. 
   
   Notes:

   • The standard out-of-the-box mapping format is "YYYY-MM-DDTHH:mm:ssZ."  
   • If the date format is not set to the standard format mentioned above, you'll have to set the Export Field Date mapping format to YYYY-MM-DDTHH:mm:ssZ.
6. On the Settings window, in Field Mapping type, select Multi-Field.
7. In the Expression field, enter the value as {{{regexReplace $.PurchaseDate "Z" ".[0-9]*Z$"}}}. 
   
   
8. On the Settings window, click Save.
9. On the Edit Mappings window, click Save and close.