Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!

Query exported columns

Avatar

Level 7

Hello, I want to see the exported Columns of a Direct Mail Delivery, but when I query the column from [output/extraction/destination/exportColumns/exportColumn/@label] i get only the first column, how can i see all the columns exported?

Heku__0-1690808669684.pngHeku__1-1690808679899.png

Thank you.

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Employee Advisor

@Heku_ ,

 

If you are only getting the first column when querying from `[output/extraction/destination/exportColumns/exportColumn/@label]`, it indicates that the XML structure you are accessing contains only one column label.

To see all the columns exported in the Direct Mail Delivery, you should check the XML structure to ensure that all column labels are present.

Each column label should be represented under the `exportColumn` node. It might look something like this:


<extraction>
<destination>
<exportColumns>
<exportColumn label="Column1" />
<exportColumn label="Column2" />
<exportColumn label="Column3" />
<!-- Additional columns go here -->
</exportColumns>
</destination>
</extraction>


Ensure all the columns you expect to be exported are listed within the `exportColumns` node. If any columns are missing, you'll need to verify the export configuration and data source settings to ensure that all the required columns are included in the export process.

If you still encounter issues, double-check the XML structure.