Transfer contacts that have opted-out of email/SMS communication

You were using a different system and now you've switched over to Loopify. You want to transfer all your contacts that have opted-out of SMS and/or email communication. You can do this by using our API. 

Transfer contacts that have opted-out of email communication

• Open your email opt-out excel file.
• Delete all the columns except the email column. All of the emails are now in column A. Make sure you have no duplicates.
• Click the first cell from column B. If the emails start from the second cell in column A, then click the second cell from column B. 
• Copy/paste the formula ="*"&A2&"*," for the selected cell in column B. Click enter.
• The first email will show up in asterisks *name@domain.com*, in the column B. Select it and drag down to apply this to all of the emails.
• Copy/paste the B column to a text document. Replace the * with " and delete the last comma.
• Go to the contacts/email/unsubscribe endpoint in our API.
• Click the authorize/padlock button to log in and get access.
• Click Try it out.
• Copy/paste the emails from the text document into the example value text area between the square brackets [].
• Click the Execute button.
• If everything is in order the HTTP Status Code should be 200.

Here is a sample code:

{
  "emails": [
   "testemail1@testdomain1.com",
   "testemail2@testdomain2.com"
 ]
}

That's it. All of your contacts that have opted-out of email communication have been added to Loopify. To see the consent info for each contact go to the Contacts app → select a contact → Consent tab. 

Transfer contacts that have opted-out of SMS communication

It's basically the same process. 

Note: Make sure that in your excel file the phone numbers are saved as plain text.

• Open your SMS opt-out excel file.
• Delete all the columns except the mobile phone column. All of the mobile numbers are now in column A. Make sure you have whitespace (CTRL+H in notepad, press space and replace all, copy back to Excel in a text formatted column) nor duplicates (go to the Data tab and select Advanced Filter and check the box "Unique records only". Copy the result into a new spreadsheet formatted as text). 
• Click the first cell from column B. If the emails start from the second cell in column A, then click the second cell from column B. 
• Copy/paste the formula ="*"&A2&"*," for the selected cell in column B. Click enter.
• The first mobile phone will show up in asterisks *+XXXXXXXXXX*, in the column B. Select it and drag down to apply this to all of the mobile phone numbers.
• Copy/paste the B column to a text document. Replace the * with " and delete the last comma.
• Go to the contacts/SMS/unsubscribe endpoint in our API.
• Click the authorize/padlock button to log in and get access.
• Click Try it out.
• Copy/paste the mobile phone numbers from the text document into the example value text area between the square brackets [].
• If everything is in order the HTTP Status Code should be 200.

Here is a sample code:

{
  "mobileNumbers": [
   "+49XXXXXXXX",
   "+49XXXXXXXX"
 ]
}

That's it. All of your contacts that have opted-out of SMS communication have been added to Loopify. To see the consent info for each contact go to the Contacts app → select a contact → Consent tab.

Note: To use this method and see the consent info for each contact, the contacts must be a part of the account. If you try to unsubscribe a contact that doesn't exist in Loopify, you can't see that they have been suppressed.