GIFE - Mapping Specs - Google Sheets

	A	C	D	E	F	G	H	I	J	K	L	M
1	Workflow 1: Given a list of {Campaign Members} from {Salesforce}, {add or update} {Member} in {Mailchimp}
2	Destination Object ID	Output Data Type	Output Sample	Source Value	Source Value (Field path)	Input Data Type	Input Sample	Transformation	Comments	Engineer's Notes	Expose in OpenFn run logs?	Personally Identifiable Information?
3	list_id	string	43fead6cd7					Always return "43fead6cd7"			Yes	No
4	members	array									Yes
5	subscriber_hash	string	patricia.lustosa@fbb.org.br		CampaignMember.Email	email	patricia.lustosa@fbb.org.br	Return CampaignMember.Email in lowercase			Yes	Yes
6	email_address	string	patricia.lustosa@fbb.org.br		CampaignMember.Email	email	patricia.lustosa@fbb.org.br				Yes	Yes
7	status	string	subscribed					Always return "subscribed" to contactsToCreate batch and omit this field in contactsToUpdate batch			Yes	No
8	full_name	string	Patricia		CampaignMember.Contact.Name	string	Patricia Lustosa				Yes	Yes
9	merge_fields.FNAME	string	Patricia		CampaignMember.Contact.FirstName	string	Patricia				Yes	Yes
10	merge_fields.LNAME	string	Lustosa		CampaignMember.Contact.LastName	string	Lustosa				Yes	Yes
11	merge_fields.MMERGE4	string	Instituto Brilhar		CampaignMember.Contact.AccountId	string	Instituto Brilhar				Yes	Yes
12	email_type	string	html					Always return "html"			Yes
13	sync_tags	boolean	FALSE					Always return "False"			Yes
14	update_existing	boolean	TRUE					Always return "True"			Yes
15	tags	array	Café com Soluções com Fundação Tide Setubal		Campaign.Nome_da_Tag__c	string	Café com Soluções com Fundação Tide Setubal		Max. 100 characteres per tag. Allows spaces.		Yes
16
17
18
19
20
21
22
23
24
25
26
27
28
29