Searching column names of table which may or may not exist in Adobe Campaign

Avatar

Avatar

felixAgung

Avatar

felixAgung

felixAgung

01-08-2017

Hi guys,

I have been tasked by my senior to find a few column name within a Database that I can't have an access to via mySQL but connected to campaign.

From my understanding, there is a schema called "Data Schema" that contains all schemas inside campaign which means it contains all the table that exist within the database. Problem is, how do I configure list that "data schema" so that it gives me the full XML information that each schema have, and from there I can do advance filter and find if the column name exist or not.

Hope my question is clear.


Regards,

Felix

View Entire Topic

Avatar

Avatar

_nkur

Avatar

_nkur

_nkur

03-08-2017

Hi Felix,

Seems like your seniors are messing around with you

I have never done it, but an idea might help.

You need right a javascript to read all the records from srcSchema and try to get attribute details.

Regards,

Ankur A.