(1) Sparkpost transaction to Update a template of the newsletter composed by the Reporter

About: Spark post API doc on PUT transaction to replace a newsletter with a new one

This is mockup of the (1)st #SparkPost transaction in Newsletter Mailing System

first GET – the HTML of the newsletter from the REPORTER at Speak To Me Catalog

then PUT – 

Body (i think this should work… never tried it exactly this way however) 
  "options": {
    "open_tracking": true
  "name": "tigger_today1”,
  "content": {
  "subject": "What you need to know about this Thursday afternoon ",
  "reply_to": "Tigger Help<customer.service@speaktomecatalog.com>",
  "html": "DATA RETIREVED FROM wherever"

Note: This particular transaction would best even happen as a result of the REPORTER writing the newsletter within the program speaktomecatalog.com/db/reporter.php … however i am not at all sure that i have the ability to send httpd transactions from that old PHP without a lot of library insstallation.  last time i tried i got my panties all wadded up null


  1. SparkPost
  2. connecting
  3. thanks
  4. kudos


Si says
Okay. So you need TD support for the mailing because pasting the html newsletter into a JSON field in Postman is a bitch.

Instead of the reporting initiating the mailing, why not the other way around? Let the TD button initiate the reporter to generate the html and then retrieve it and submit the mailing?

Seth says
The reporter itself is a long procedure in its own right where me and denise interactively talk about what the newsletter is to achieve and select products to be advertised.   Typically that happens over several hours and is frequently interrupted.  The final click when we are finished the design writes the HTML.  For that all to be under a TD click is hard to imagine.

But it is easy to just do a GET from TD of the HTML once it is written.

Alternatively i could put the POST to spark post in the REPORTER php program to happen the same place it is writing the HTML.   +$50 if you want to do it that way … as that would save a complete step in the procedure.  I just was not able to do that in the old PHP at speaktomecatalog.com.

Si says
I could put the emailing at the end of the reporter, but it seems less stable and flexible.

I personally would want to look at the final HTML before it got used, and then, what about test verses live? That seems better done as TD based buttons than trying to put all that in the reporter output. Having it on the TD side would allow you to tweak the JSON involved anytime you wanted … on the PHP side it would all be burned in.

Si says
And yes, just have the reporter produce HTML. Too much being done there to initiate it from TD.
  1. Reporter makes HTML.
  2. TD buttons for “test” and “live” each retrieve the HTML and submit it to sparkpost.
  3. The JSON under the buttons can be tweaked anytime desired.
  4. The bounces button already works as needed and the dates in it are easily tweaked with the TD editor.

Seth says
the final step in the REPORTER shows me the newsletter on the screen, just like a customer would see it.  Then step (3a) sends it out to me and denise in test.  Typically denise reads it in her gmail then,  and makes changes and then i regenerate before sending it out live (3b).

But shucks i agree doing it in the TD script works just fine if that script can GET  from speaktomecatalog.com/newsletters/2017-05-10.html   and POST that in the Jason to sparkpost.  The name of the file does not even need to vary … it could always be something like current_newsletter.html .

Seth says

Si says
Yes. Easy to grab html especially if in one file name.

So steps 1, 3, 3, and 4 in Newsletter Mailing System are covered.

How to cover step 2?

p.s. Suggest writing the HTML to both a date based file and a constant file name. That way you have a back copy record as well.

Seth says

Seth says
I’ll write a thought for 2 … give me a moment … it is a POST and does not need any variables.

totally agree on p.s.   … all i need to do on that is leave it the way it is and just add an extra write for the separate constant file “current_newsletter.html” … we never juggle more than one of these at a time.

Si says

Seth says
#done see  (2) Post the mailing list to SparkPost

Si says

I am ready to test a sparkpost emailing.

I need the exact body above to try, not a rough one (except the html content object which I will dynamically fill in).

… also, if you can make up a test email list that includes just you and me that would be swell.


Seth says
okay give me a moment. #done

Seth says
the test list with just you and me is at www.speaktomecatalog.com/tiggerandhobbs.csv

but that does not go into this particular transaction above which just registers the actual email to send out, but does not send it out.

if it works the template will show up in the #SparkPost templates at  https://app.sparkpost.com/templates
to sign on to the dashboard … see (private thought) (comment 77862).

Si says

Si says
Well, we either need to figure out what you are talking about for step #2 and converting formats and using it to create the test email list … or … you can simply put the tiggerandhobbs email list up at sparkpost so we can do test emailings and see if the publish status and all else works.

Because all I need to activate the “send test emails” button and test the whole process is a valid email list to refer to by name.

Seth says
yes … which is why i created the “tigger and hobs email list” upon your request … the data is here … i already FTP’d it for us …. http://www.speaktomecatalog.com/tiggerandhobbs.csv

if you click that it should downlonad to your local computer … then step 2 should (ideally) ask for an upload (of what you just downloaded by example)  and convert the data for the Json object.   Typically this data will be about 10k of records.

it is ideal for my work if i don’t need to FTP from denise’s computer to the web to send the list to sparkpost.  That would be an extra step that i prefer to eliminate.  So i’d like to upload to the TD procedure directly from denise’s hard drive.  Unfortunately i do need to interface with this legacy FoxPro system on her computer which is a bitch to connect to the web.

… and to be fair to you … another +$50 for the upload ability.

sorry null, #connecting at times is like opening a can of worms and combing the hair null

Si says
So Denise’s computer can access FBI okay? That actually surprises me considering it’s age and that FBI relies on HTML 5.

Seth says
well it can … but i don’t actually user her computer for the web interface.   rather i go on her computer and generate the list to her hard drive.  then i go on my mac and call up fastblogit and then upload choosing the file on denises hard drive in the process.  our computers are networked together.

Si says
Okay. That is easier.

Seth says
i modified REPORTER to put the subject of the email in the <title> element of the HTML newsletter.

#done → seth

Si says
Okay. The script is already modified to use the input field if not empty and the <title> otherwise.

Seth says

Seth says
any new emails generated by the REPORTER should have a title now.  
it’s great that we can also overide that with an input field in the procedure itself.
#thanks & #kudos → nathan

See Also

  1. Thought Newsletter Mailing System with 1965 viewings related by tag "sparkpost".
  2. Thought #Integrity #authenticity with 460 viewings related by tag "connecting".
  3. Thought Project: Sparkpost for Speak To Me Catalog with 371 viewings related by tag "SparkPost".
  4. Thought Well here i am back in this reality with 312 viewings related by tag "kudos".
  5. Thought Diagram of Speak.txt system with 310 viewings related by tag "sparkpost".
  6. Thought [title (23251)] with 262 viewings related by tag "thanks".
  7. Thought Requirements for emailing with 249 viewings related by tag "SparkPost".
  8. Thought (4) After mailing is finished - Sparkpost transaction to retrieve the bounces with 201 viewings related by tag "SparkPost".
  9. Thought #SparkPost with 175 viewings related by tag "SparkPost".
  10. Thought How does blockchain go beyond what we already have in GCP ? with 139 viewings related by tag "thanks".
  11. Thought API Procedure to mail a Newsletter with 132 viewings related by tag "SparkPost".
  12. Thought To upload mp3 files to Fillmore box 6300 with 129 viewings related by tag "kudos".
  13. Thought Unsubscribe to Speak To Me Catalog newsletter with 108 viewings related by tag "SparkPost".
  14. Thought Go Mark! with 102 viewings related by tag "kudos".
  15. Thought 3 state logic with 90 viewings related by tag "thanks".
  16. Thought 2016C - FALL CD catalog production with 86 viewings related by tag "kudos".
  17. Thought Making up Others with 85 viewings related by tag "kudos".
  18. Thought (3a & 3b) SparkPost transaction that acctually dispatches a mailing with 77 viewings related by tag "SparkPost".
  19. Thought REPORTER with 77 viewings related by tag "thanks".
  20. Thought Connecting the seemingly unconnected ... with 67 viewings related by tag "connecting".
  21. Thought BlackListt speaktomecatalog.com ... get speaktomecatalog off the list with 57 viewings related by tag "SparkPost".
  22. Thought Amazon's Buy Box Games with 52 viewings related by tag "kudos".
  23. Thought 1705a with 52 viewings related by tag "SparkPost".
  24. Thought (2) Post the mailing list to SparkPost with 52 viewings related by tag "SparkPost".
  25. Thought Speak.txt - mailing Procedure with 50 viewings related by tag "SparkPost".
  26. Thought Setting up a bounce domain for Sparkpost with 44 viewings related by tag "SparkPost".
  27. Thought Fo Hammer popped up at the FBI today. with 43 viewings related by tag "kudos".
  28. Thought Pride & Thanks feel Good with 26 viewings related by tag "thanks".
  29. Thought Email Chatbots with SparkPost with 25 viewings related by tag "SparkPost".
  30. Thought Marketing Stratagies for Speak To Me Catalog with 20 viewings related by tag "SparkPost".
  31. Thought Footer problem on individual page at speaktomecatalog.com with 19 viewings related by tag "kudos".
  32. Thought Beard Gauge with 19 viewings related by tag "thanks".
  33. Thought about: the right tension of links with 18 viewings related by tag "connecting".
  34. Thought Meatloaf with 17 viewings related by tag "kudos".
  35. Thought Lovely tag cloud! with 16 viewings related by tag "kudos".
  36. Thought A mailer in the Cloud with 16 viewings related by tag "SparkPost".
  37. Thought Bookmarks Love with 15 viewings related by tag "kudos".
  38. Thought Your Role in the State of Email - Webinar with 15 viewings related by tag "SparkPost".
  39. Thought Sweet Potato Fries with 13 viewings related by tag "thanks".
  40. Thought about: how it works - ideabuzz with 13 viewings related by tag "kudos".
  41. Thought Probably the most pertinant speech yet this century with 11 viewings related by tag "kudos".
  42. Thought OMG We are back in business ... with 11 viewings related by tag "kudos".
  43. Thought sparkpost API documentation with 7 viewings related by tag "SparkPost".
  44. Thought Conversations are Kewl with 6 viewings related by tag "kudos".
  45. Thought Conversation Rooms with 1 viewings related by tag "kudos".
  46. Thought Happy Thanksgiving! with 0 viewings related by tag "thanks".
  47. Thought new razberry blue emotlets with 0 viewings related by tag "thanks".