Access data from data loading file activity | Community
Skip to main content
prachi1
New Participant
Apr 7, 2022 9:29 AM UTC
Question

Access data from data loading file activity

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.

4 replies

_Manoj_Kumar_
_Manoj_Kumar_
New Participant
Apr 7, 2022 10:07 AM UTC

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.

Translate
     Manoj     Find me on LinkedIn
    prachi1Author
    New Participant
    Apr 7, 2022 12:41 PM UTC

    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.

    Translate
    _Manoj_Kumar_
    _Manoj_Kumar_
    New Participant
    May 18, 2022 11:06 AM UTC

    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.

    Translate
         Manoj     Find me on LinkedIn
    Terms & ConditionsAccessibility statement

    Loading footer...