Expandir minha barra de realizações na Comunidade.

Submissions are now open for the 2026 Adobe Experience Maker Awards.
SOLUCIONADO

Can we add Current timestamp dynamically in mapping set

Avatar

Community Advisor

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!!
1 Solução aceita

Avatar

Resposta correta de
Community Advisor

it worked with below 

"sourceType""EXPRESSION",
          "source""{{now()}}",
          "destination""_XXXXX.systemTime"
      }
 
Thanks for your inputs

Ver solução na publicação original

6 Respostas

Avatar

Community Advisor and Adobe Champion

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

 

IMG_9312.jpeg

 

 

 

Cheers from Switzerland!


Avatar

Community Advisor

Tried, not working 

Avatar

Community Advisor and Adobe Champion

Hi @Indra 

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

 

bjoern__koth_1-1736400996697.png

 

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

 

bjoern__koth_0-1736400948696.png

 

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

Cheers from Switzerland!


Avatar

Community Advisor

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

 

foundation/conversion/mappingSets

Avatar

Resposta correta de
Community Advisor

it worked with below 

"sourceType""EXPRESSION",
          "source""{{now()}}",
          "destination""_XXXXX.systemTime"
      }
 
Thanks for your inputs

Avatar

Administrator

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



Kautuk Sahni