Using a Data Schema for one off send | Community
Skip to main content
B
bsybydlo-1
June 4, 2021
Solved

Using a Data Schema for one off send

  • June 4, 2021
  • 1 reply
  • 1672 views

Hello! 

 

I am developing an email that will send using a specific data schema, but I do not have that schema in my sandbox.  I am wondering if the correct flow for this would be to start a workflow -> call the data schema in question -> populate the variables - but how would I populate the data schema with the data I need for the send? 

 

Also, is there a way to do this as a proof or individual send? Or do I have to run a workflow in order to call the schema in question? 

 

Thank you.

 

-Bob 

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

Hi bob,

is this "data schema" is like the recipient schema?

I mean: it contains all the columns that you need for your sending including the custom variables?

 

If yes, be sure to create a target mapping dedicated to your schema: Target mapping | Adobe Campaign

Once done, you can import in a workflow a CSV file to insert/update required columns in the "data schema" and then use a query activity to select it in order to target your delivery population

 

But... That's the technical aspect, for my part, as you could use directly the CSV file with an import activity and use the existing "mapAny" target mapping. Is there any special requirement to build a dedicated schema?

 

 

 

1 reply

LaurentLam
LaurentLamAccepted solution
Level 5
June 4, 2021

Hi bob,

is this "data schema" is like the recipient schema?

I mean: it contains all the columns that you need for your sending including the custom variables?

 

If yes, be sure to create a target mapping dedicated to your schema: Target mapping | Adobe Campaign

Once done, you can import in a workflow a CSV file to insert/update required columns in the "data schema" and then use a query activity to select it in order to target your delivery population

 

But... That's the technical aspect, for my part, as you could use directly the CSV file with an import activity and use the existing "mapAny" target mapping. Is there any special requirement to build a dedicated schema?

 

 

 

LaurentLam
LaurentLam
Level 5
June 4, 2021
you can do it even easier: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/how-to-launch-from-external-file-s-email-column/qaq-p/234146 just don't forget that through this external file mapping, you'll have to call your custom columns with "datasource.myCustomColumn"
Terms & ConditionsAccessibility statement

Loading footer...