Expand my Community achievements bar.

SOLVED

Manual CSV File Mapping for "idSpecific" Objects in the UI

Avatar

Level 2

Hi all,

I am wondering how manual CSV file mapping will work with the idSpecific object in the UI. Specifically, in some systems, we can only generate CSV consent for specific emails.

 

If the data comes in CSV format, how can we map the idSpecific using the UI? We need to use idSpecific because a user might have different email addresses and consent status for each of these emails.

 

For example, our data is in a table format like this:

membershipIDemailconsent
abc123test_1@example.comy
abc123test_2@example.comn

 

How can we map this data in the UI as an idSpecific object like below? Wondering if we can use any wildcard char for this mapping works?

"idSpecific": {
  "email": {
    "test_1@example.com": {
      "marketing": {
        "email": {
          "val": "y"
        }
      }
    },
    "test_2@example.com": {
      "marketing": {
        "email": {
          "val": "n"
        }
      }
    }
  }
}

 

 


Thanks,
Imv

1 Accepted Solution

Avatar

Correct answer by
Level 4

"consents": { "collect": { "_adobexxxxxx": { "Email": f"john.smith{i}@abc.com" }, "val": "y" }

"consents": { "collect": { "_adobeqxxxxxx": { "Email": f"john.smith11{i}@abc.com" }, "val": "n"}

 

 

 

 

View solution in original post

6 Replies

Avatar

Community Advisor

@bestImv create a custom field group and pass multiple email address in an array, assuming membership id is primary key you can map multiple emails with consents. 

Ideally you will create a custom consent field group and pass consent for other channels within the same field group 

 

Hope that helps 

Anil

Avatar

Correct answer by
Level 4

"consents": { "collect": { "_adobexxxxxx": { "Email": f"john.smith{i}@abc.com" }, "val": "y" }

"consents": { "collect": { "_adobeqxxxxxx": { "Email": f"john.smith11{i}@abc.com" }, "val": "n"}

 

 

 

 

Avatar

Level 2

Thanks @Anil_Umachigi  for the suggested solution, we are now implementing it.

Cheers,
Imv