Dear Community,
I have one technical question: One of my Marketing cloud client want to dynamically extract DE in a Particular folder to SFTP as a csv or json file. Folder path:
Data Extensions >Interactive Content.
I have tried Pivoting the DE using SQL activity but for Future DEs I need to keep adding the SQl Activity. So client wants to Dynamically extracts DEs from the Folder to SFTP.
Do you have any suggestions to achieve this or any use case from past experience will help me a lot.
Thank you,
Guru
#Trailhead Challenges #Trailhead #SFMC #Marketing Cloud #Marketing Cloud Engagement #AgentforceMarketing
To achieve this, the script runs in two steps: first, it queries the datafolder object using wsProxy to retrieve the categoryid of the target folder (data extensions > interactive content).
Once the folder ID is retrieved, it queries the dataExtension object to fetch the customerKey and Name of every DE located within that specific CategoryID.
