Can we add Current timestamp dynamically in mapping set

Question

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!!

Indra-2 · Accepted Answer

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

foundation/conversion/mappingSets

it worked with below

"sourceType": "EXPRESSION",

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

"destination": "_XXXXX.systemTime"

}

Thanks for your inputs

bjoern-koth · Answer

Hi @indra-2  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

Sign up

Login with SSO

Login to the community

Login with SSO