About NCJTC

Has anyone had luck setting up token retrieval in Postman API?   I can get the token when going through the folder authorization steps, but not when trying to create POST/GET requests. Using the "Get New Access Token" method in the folder authorization, I am required to login every time. This is not sustainable.   For anyone with experience with this, I am attempting to follow the steps here. 1. In Postman, I create a GET request. GET https://api.cc.email/v3/idfed? Params: client_id: {{clientid}} (same as in the Get New Access Token process) redirect_uri: https://localhost (same is in the Get New Access Token process) response_type: code scope: contact_data+campaign_data   2. This returns an HTML form that does not seem to work in Postman.   3. I am expecting to get an authorization code, but I do not see where this comes from.    4. Attempting to send a POST request to the https://idfed.constantcontact.com/as/token.oath2?code=????&redirect_uri= https%3A%2F%2flocalhost&grant_type=authorization_code   Headers:  Authorization: Basic (base64 {{clientid}}:{{API Secret}}) Content-Type: application/x-www-form-urlencoded   Response is: { "error_description": "unable to parse Authorization header javax.security.auth.login.LoginException: No credentials provided with BasicAuthorization", "error": "invalid_client" }   ... View more

Is there any reason that my contact count for a list when logging in to Constant Contact would not match the count when using the API?   In this example, I have a list called "Not Identified." When I use the API, it returns 61,207 contacts. When I login to Constant Contact, I see 63,438.   What accounts for the discrepancy? ... View more

This requires VBA-JSON (https://github.com/VBA-tools/VBA-JSON).   In Excel, open Visual Basic (alt+F11).  Select tools -> References and select Microsoft XML, v6.0   Create a new module and paste this. You can customize it as needed. Public Sub GetRegistrations() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim strURL, strRURL, eID As String eID = {your event ID} strEURL = "https://api.constantcontact.com/v2/eventspot/events/" & eID & "/registrants?limit=500&api_key={Your API Key}" Dim objrequest As New MSXML2.XMLHTTP60 With objrequest .Open "Get", strEURL, False .setRequestHeader "Authorization", "Bearer " & "{Your Token}" .send End With strPostResponse = objrequest.responseText Dim eParsed As Dictionary Set eParsed = JsonConverter.ParseJson(strPostResponse) For a = 1 To eParsed("results").Count rID = eParsed("results")(a)("id") strRURL = "https://api.constantcontact.com/v2/eventspot/events/" & eID & "/registrants/" & rID & "?api_key={Your API Key}" Dim objrequest2 As New MSXML2.XMLHTTP60 With objrequest2 .Open "Get", strRURL, False .setRequestHeader "Authorization", "Bearer " & "{Your Token}" .send End With strPostResponse2 = objrequest2.responseText Dim rParsed As Dictionary Set rParsed = JsonConverter.ParseJson(strPostResponse2) Debug.Print JsonConverter.ConvertToJson(rParsed, Whitespace:=2) For b = 2 To rParsed("sections").Count Cells(LR + a + 1, 1).Value = eParsed("results")(a)("first_name") Cells(LR + a + 1, 2).Value = eParsed("results")(a)("last_name") Cells(LR + a + 1, 3).Value = eParsed("results")(a)("email") Cells(LR + a + 1, 4).Value = rParsed("sections")(3)("fields")(1)("value") 'these can be updated depending on your requirements Cells(LR + a + 1, 5).Value = rParsed("sections")(2)("fields")(6)("value") Cells(LR + a + 1, 6).Value = rParsed("sections")(2)("fields")(7)("value") Cells(LR + a + 1, 7).Value = rParsed("sections")(3)("fields")(2)("value") Cells(LR + a + 1, 8).Value = rParsed("sections")(3)("fields")(3)("value") Cells(LR + a + 1, 9).Value = rParsed("sections")(3)("fields")(6)("value") Cells(LR + a + 1, 10).Value = rParsed("sections")(3)("fields")(7)("value") Next Next Range("M1").Value = "Last Updated " & Format(Now(), "MM/DD/YYYY") Application.ScreenUpdating = True Application.Calculation = xlCalculateAutomatic End Sub In this particular event, the rParsed sections look like this: rParsed("sections")(1) is Custom1 rParsed("sections")(2) is Personal Information rParsed("sections")(3) is Business Information rParsed("sections")(4) is Custom2   I don't know if that will be true for every event.    In my case, I have this running in a spreadsheet -- I call the sub on open, and I added a button to process it on demand. ... View more

Issue: MS Outlook does not display background images in <table> or <td> tags. This means that text in a graphic is not able to be viewed by our readers unless an option is selected to download images. It also means that to use images, the text must be on the graphic itself.   Resolution: Using the custom code advanced editor, use VML code similar to the following:   <td background="http://i.imgur.com/YJOX1PC.png" bgcolor="#7bceeb" width="640" height="130" valign="top">   <!--[if gte mso 9]>   <v:rect xmlns:v="urn:schemas-microsoft-com:vml" fill="true" stroke="false" style="width:640px;height:130px;">     <v:fill type="tile" src="http://i.imgur.com/YJOX1PC.png" color="#7bceeb" />     <v:textbox inset="0,0,0,0">   <![endif]-->   <div>   This text appears on top of the image, even in MS Outlook.     </div>   <!--[if gte mso 9]>     </v:textbox>   </v:rect>   <![endif]--> </td>   Suggestion to Constant Contact: It would be great if this code were able to be used in the template editor or even have a tool button  created that automatically inserts this code (WYSIWYG).   Urgency level: This is the next great innovation in email marketing technology. ... View more