Access data from data loading file activity | Community
Skip to main content
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
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
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
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