Can we add Current timestamp dynamically in mapping set

[Indra]

Hi All,

We are using parquet file format and in mapping set I am trying to insert current timestamp into one of the attributes.

Tried below Mapping configuration

 "sourceType": "ATTRIBUTE",

          "source": "current_timestamp()",

          "destination": "_XXXXX.systemTime"

      }

"sourceType": "ATTRIBUTE",

          "source": "{{now()}}",

          "destination": "_XXXXX.systemTime"

      }

Timestamp is not ingested. any help will be appreciated!!

[bjoern__koth]

Hi @Indra 

you may want to check out the "date and time functions" section in the documentation 

https://experienceleague.adobe.com/en/docs/experience-platform/data-prep/functions

 

[Indra]

Tried, not working 

[bjoern__koth]

Hi @Indra 

just tried to reproduce this by a datastream mapping with now() to prop9 in the datastream mapping configuration.

In my assurance session, I can see the timestamp being mapped

Waiting for the data to show in AA, but I am fairly certain that this should work at least on that side.

Wondering whether why it should be any different in your mapping.

Else, I would reach out to support about this

[Indra]

I am trying to set current date in mapping set and using API to set this.

foundation/conversion/mappingSets

[Indra · Accepted solution]

it worked with below 

"sourceType": "EXPRESSION",

          "source": "{{now()}}",

          "destination": "_XXXXX.systemTime"

      }

Thanks for your inputs

[kautuk_sahni]

@Indra Did you find the suggestions helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!