Access data from data loading file activity | Community
Skip to main content
P
prachi1
April 7, 2022
Question

Access data from data loading file activity

  • April 7, 2022
  • 1 reply
  • 1722 views

Hi, I want to access data from data loading file activity which contains csv file uploaded (i.e firstName) and access that target data to email delivery and update it into some another schema

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
April 7, 2022

Hello @prachi1 

 

You can use the data loading activity and then the enrichment activity.

In the enrichment activity, you can add the first name column in additional data and use it in delivery.

Manoj  | https://themartech.pro
    P
    prachi1Author
    April 7, 2022

    Hi Manoj_Kumar 

    Thanks for suggestions , but also I want to access that target data in JavaScript so how can I use that target data in JavaScript code and will hold target data in variable and use that variable in delivery.

    Manoj_Kumar
    Community Advisor
    Manoj_KumarCommunity Advisor
    Community Advisor
    May 18, 2022

    Hello @prachi1 

     

    You can get the data by queryDef

     

    Here is a sample code:

    var query = xtk.queryDef.create(
  <queryDef schema="{vars.targetSchema}" operation="select">
    <select>
      <node expr="@internalName"/>
    </select>
  </queryDef>
)

var res = query.ExecuteQuery()

for each (var w in res.workflow)
  logInfo(w.@internalName)

    vars.targetSchema will give you the temporary table generated by the previous activity.

    Manoj  | https://themartech.pro
    Terms & ConditionsAccessibility statement

    Loading footer...