• If you want to apply the same update to all of the users specified, you should pass the update parameter.
• You must pass one of the required parameters, but not more than one: emails, url, file, or query

• The exported URL contains PII hashed data for users’ email addresses. extid values are unencrypted. To obtain unencrypted email addresses, perform an export in my.sailthru with two-factor (SMS) verification.
• For export jobs, export_url will return if the job is completed and not expired. If the job is expired, expired field with value true will return.

• Querying a list is not required, since you are already querying the blast itself

• start_date and end_date‘s format: yyyymmdd. Example: 20150115
• The range between start_date and end_date cannot exceed 31 days

• The exported URL contains PII hashed data. Using the fields parameter limits the CSV export to those specific fields (in addition to Profile ID and Email Hash).
• Valid fields values:
  • clicks
  • domain
  • email_message
  • email_status
  • email_status_time
  • engagement
  • first_purchase_time
  • geolocation_city
  • geolocation_country
  • geolocation_state
  • geolocation_zip
  • largest_purchase_item_price
  • last_click
  • last_open
  • last_pageview
  • last_purchase_time
  • lifetime_message
  • lists
  • list_signup
  • opens
  • optout_time
  • pageviews
  • profile_created_date
  • purchase_count
  • purchase_incomplete
  • purchase_price
  • signup
  • top_device
  • vars

• In addition to list, you must pass one of the following parameters, but not all three:
  • emails
  • file
  • url

• This is not a URL! File must be a CSV or text file with one email per line
• The maximum upload file size is 1 GB

• You must upload a CSV file with the first column titled “email,” and the second column titled “signup_date.”
• Pass 1 or true to overwrite or set custom signup dates for existing users or new users
• Date variables cannot be in UNIX.
• How to set Custom Signup Dates
• job Examples

• The file must contain one JSON object per line (separated by hard returns, not commas)
• Each object must match the purchase API POST format, with the following exceptions:
  • date and extid are required
  • the following parameters should not be included, as they only apply to purchases recorded in realtime: message_id, incomplete, reminder_template, send_tempate, reminder_time
• Max file size is 1 GB

Note: Active Lifecycle Optimizer flows with “Made Purchase” entries will include purchases added from this job type. Turn off any purchase-based Lifecycle Optimizer flows temporarily while running the purchase_import job. If you don’t turn off your LO flows, this job could trigger a large number of entries.

• If you are using the url or file parameters, then you are pulling data from a url or file. There are two different formats you can use:
  • Simple – Email address per line. This lets you perform the same update on a list of users.
  • JSON – JSON object per line. This lets you specify individual updates on a per-user basis. Each line should contain a JSON object with the email element to identify the user, and any optional parameters: vars, lists, or optout.

• The maximum upload file size is 1 GB
• If you are using the url or file parameters, then you are pulling data from a url or file. There are two different formats you can use:
  • Simple – Email address per line. This lets you perform the same update on a list of users.
  • JSON – JSON object per line. This lets you specify individual updates on a per-user basis. Each line should contain a JSON object with the email element to identify the user, and any optional parameters: vars, lists, or optout.

• Valid optout values:
  • all – Opts users out of all communications
  • basic – Opts the user out of all communications except templates marked as “basic”
  • none – Opts the user back in

FURTHER INFORMATION:
User Opt-Out Levels

• This process is irreversible, so proceed with caution

{
    "job_id":"4dd58f036803fa3b5500000b"
}

{
    "job_id":"4dd58f036803fa3b5500000b",
    "name":"List Import",
    "status":"completed",
    "start_time":"Fri, 20 May 2012 13:50:28 -0400",
    "end_time":"Fri, 20 May 2012 13:55:10 -0400",
    < The remaining info depends on the job type >
}

{
    "job":
}

{
    "job":"blast_query",
    "blast_id":190940
}

{
    "filename":"my-list.csv"
}

{
    "export_url":"https://s3.amazonaws.com/sailthru/path/to/export"
}

{
    "job":"blast_save_list",
    "blast_id":123456,
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        },
     "list":"Opened-Jun-15-Campaign"
}

{
    "job":"blast_save_list",
    "blast_id":123456,
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        },
     "list":"Opened-Jun-15-Campaign"
}

{
    "job":"blast_save_list",
    "blast_id":123456,
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        },
     "list":"Opened-Jun-15-Campaign"
}

{
    "job":"blast_save_list",
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        }     
    "list":"Opened-Jun-15-Campaign",
    "report_email":"example@sailthru.com"
}

{
    "job":"blast_snapshot",
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        },
    "blast_id":190940
}

{
    "job":"content_update",
    "file":"/tmp/file.txt"
}

File content

{"url":"https://example.com/1234/water_bottle" }
{"url":"https://example.com/1234/water_bottle-outdoor", "inventory":47}
{"url":"https://example.com/1234/water_bottle-sport", "title":"Sports Water Bottle",
"description":"A water bottle designed for athletes"}

{
 "job" : "delete_content",
 "type" : "all"
}

Delete all expired content:

{
 "job" : "delete_content",
 "type" : "expired"
}

{
 "job" : "delete_content",
 "type" : "all",
 "start_date" : "July 1, 2016",
 "end_date" : "Dec 31, 2016"
}

Delete only expired content published in the last 6 months of 2016 including the specified dates:

{
 "job" : "delete_content",
 "type" : "expired",
 "start_date" : "2016-07-01",
 "end_date" : "2016-12-31"
}

{
    "job":"export_list_data",
    "list":"MyUsers"
}

{
    "job":"export_list_data",
    "list":"MyUsers",
    "fields":
        {
            "opens":1,
            "vars":
                {
                    "userId":1,
                    "user_type":1
                }
        }
}

{
    "job":"export_purchase_log",
    "start_date":20120131,
    "end_date":20120131
}

{
    "job":"import",
    "list":"My List"
}

{
    "job":"import",
    "list":"My List",
    "emails":
        "example1@sailthru.com,example2@sailthru.com,example3@sailthru.com"
}

{
    "job":"import",
    "list":"My List",
    "file":".../Users/myusername/Documents/myfile.csv"
}

{
    "job":"import",
    "list":"My List",
    "url":"https://www.example.com/feed/ourfeed"
}

{
    "job":"import",
    "list":"My List",
    "url":"https://www.example.com/feed/ourfeed"
    "signup_dates":1
}

{
    "job":"snapshot",
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        }   
}

{
    "job":"update",
    "url":"https://example.com"
}

See also: Bulk update JSON file example.

{"id":"user1@example.com", "keys":{"extid":"12"}, "fields":{"keys":1}, "vars":{"updated":"yes"}, "lists":{"Update List":1}}
{"id":"user2@example.com", "keys":{"extid":"13"}, "fields":{"keys":1}, "lists":{"Update List":0}}
{"id":"user3@example.com", "keys":{"extid":"14"}, "fields":{"keys":1}, "optout":"all"}
{"id":"user4@example.com", "signup_date":"1987-08-01"}

Object 1: Adding a key, adding a var, adding to a list
Object 2: Adding a key, removing from a list
Object 3: Adding a key, setting status to optout all
Object 4: Setting custom signup date

{
   "id":"user1@example.com",
   "keys":{"extid":"12"},
   "fields":{"keys":1},
   "vars":{"updated":"yes"},
   "lists":{"Update List":1}
}
{
   "id":"user2@example.com",
   "keys":{"extid":"13"},
   "fields":{"keys":1},
   "lists":{"Update List":0}
}
{
   "id":"user3@example.com",
   "keys":{"extid":"14"},
   "fields":{"keys":1},
   "optout":"all"
}
{
   "id":"user4@example.com",
   "signup_date":"1987-08-01"
}

{
    "job":"update",
    "query":
        {
            "source_list":"Main",
            "criteria":["engagement_min"],
            "engagement":[5]
        }
}

{
    "job":"update",
    "query":{"source_list":"Main"},
    "update":
    {
        "vars":
        {
            "name":"Joe One",
            "company":"Example Company"
        }
    }
}

{
    "job":"update",
    "query":{"source_list":"Main"},
    "update":
        {
            "lists":
                {
                    "Main-copy":1
                }
        }
}

or

{
    "job":"update",
    "query":{"source_list":"Main"},
    "update":
        {
            "email":"example1@example.com",
            "lists":
                {
                    "Main-copy":1
                }
        },
        {
            "email":"example2@example.com",
            "lists":
                {
                    "Main-copy":0
                }
        }
}

{
    "job":"update",
    "query":{"source_list":"mylistname"},
    "update":{"optout":"all"}
}

{
    "job":"update",
    "query":
        {
            "source_list":"Main"
        },
    "update":
        {
            "delete_vars":
                [
                    "name",
                    "company"
                ]

        }
}

{"email":"someone@somedomain.com", "signup_date":"Jan 18, 2013"}

{
    "job":"purchase_import",
    "file":"/tmp/file.txt"
}

File Content (Supported format: one object per line)

{"email":"user1@example.com","date":"2016-06-01","purchase_keys":{"extid":"purchase101"},"items":[{"qty":1,"id":"2005","title":"T-Shirts in Black","url":"http://example.com/products/tshirts-black","price":4000,"tags":["shirts","under100","color-black"],"vars":{"sailthru_category":"clothing"},"image":"http://email-media.s3.amazonaws.com/Sailthru/default/images/stock/t-shirts.jpg"},{"qty":1,"id":"SKU1002","title":"Women's Shoes in Black and White","url":"http://example.com/products/womens-shoes-in-black","price":25000,"tags":["shoes","footwear","formalwear","womens","color-black"],"vars":{"sailthru_category":"shoes"},"image":"http://email-media.s3.amazonaws.com/Sailthru/default/images/stock/high_heels.jpg"},{"qty":2,"id":"SKU1001","title":"Men's Shoes in Black","url":"http://example.com/products/mens-shoes-in-black","price":10000,"tags":["shoes","footwear","formalwear","mens","color-black"],"vars":{"sailthru_category":"shoes"},"image":"http://email-media.s3.amazonaws.com/Sailthru/default/images/stock/black_mens_shoes.jpg"}],"vars":{"order_level_var":"abcd1234"},"adjustments":[{"price":-5000,"title":"Sale"},{"price":-2000,"title":"coupon"}]}
{"email":"user2@example.com","date":"2016-06-02","purchase_keys":{"extid":"purchase202"},"items":[{"qty":2,"id":"2005","title":"T-Shirts in Black","url":"http://example.com/products/tshirts-black","price":4999,"tags":["shirts","under100","color-black"],"vars":{"sailthru_category":"clothing","item_level_var":"promotional_item"},"image":"http://email-media.s3.amazonaws.com/Sailthru/default/images/stock/t-shirts.jpg"}],"vars":{"order_level_var":"efhg6789"},"tenders":[{"price":"9998","title":"Discover"}]}
{"email":"user3@example.com","date":"2016-06-03","purchase_keys":{"extid":"purchase303"},"items":[{"qty":1,"id":"SKU1002","title":"Women's Shoes in Black and White","url":"http://example.com/products/womens-shoes-in-black","price":24900,"tags":["shoes","footwear","formalwear","womens","color-black"],"vars":{"sailthru_category":"shoes"},"image":"http://email-media.s3.amazonaws.com/Sailthru/default/images/stock/high_heels.jpg"},{"qty":1,"title":"Men's Shoes in Black","id":"SKU1001","url":"http://example.com/products/mens-shoes-in-black","price":19999,"tags":["shoes","footwear","formalwear","mens","color-black"],"vars":{"sailthru_category":"shoes"},"image":"http://email-media.s3.amazonaws.com/Sailthru/default/images/stock/black_mens_shoes.jpg"}],"vars":{"order_level_var":"shoes_purchase"},"adjustments":[{"price":2500,"title":"Express Shipping"}]}

{
  "email": "user1@example.com",
  "date": "2016-06-01",
  "purchase_keys": {
    "extid": "purchase101"
  },
  "items": [{
    "qty": 1,
    "id":"2005",
    "title": "T-Shirts in Black",
    "url": "http://example.com/products/tshirts-black",
    "price": 4000,
    "tags": ["shirts", "under100", "color-black"],
    "vars": {
      "sailthru_category": "clothing"
    },
    "image": "http://example.com/images/stock/t-shirts.jpg"
  }, {
    "qty": 1,
    "id":"SKU1002",
    "title": "Women's Shoes in Black and White",
    "url": "http://example.com/products/womens-shoes-in-black",
    "price": 25000,
    "tags": ["shoes", "footwear", "formalwear", "womens", "color-black"],
    "vars": {
      "sailthru_category": "shoes"
    },
    "image": "http://example.com/images/stock/high_heels.jpg"
  }, {
    "qty": 2,
    "id":"SKU1001",
    "title": "Men's Shoes in Black",
    "url": "http://example.com/products/mens-shoes-in-black",
    "price": 10000,
    "tags": ["shoes", "footwear", "formalwear", "mens", "color-black"],
    "vars": {
      "sailthru_category": "shoes"
    },
    "image": "http://example.com/images/stock/black_mens_shoes.jpg"
  }],
  "vars": {
    "order_level_var": "abcd1234"
  },
  "adjustments": [{
    "price": -5000,
    "title": "Sale"
  }, {
    "price": -2000,
    "title": "coupon"
  }]
}

{
  "email": "user2@example.com",
  "date": "2016-06-02",
  "purchase_keys": {
    "extid": "purchase202"
  },
  "items": [{
    "qty": 2,
    "id":"2005",
    "title": "T-Shirts in Black",
    "url": "http://example.com/products/tshirts-black",
    "price": 4999,
    "tags": ["shirts", "under100", "color-black"],
    "vars": {
      "sailthru_category": "clothing",
      "item_level_var": "promotional_item"
    },
    "image": "http://example.com/images/stock/t-shirts.jpg"
  }],
  "vars": {
    "order_level_var": "efhg6789"
  },
  "tenders": [{
    "price": "9998",
    "title": "Discover"
  }]
}

{
  "email": "user3@example.com",
  "date": "2016-06-03",
  "purchase_keys": {
    "extid": "purchase303"
  },
  "items": [{
    "qty": 1,
    "id":"SKU1002",
    "title": "Women's Shoes in Black and White",
    "url": "http://example.com/products/womens-shoes-in-black",
    "price": 24900,
    "tags": ["shoes", "footwear", "formalwear", "womens", "color-black"],
    "vars": {
      "sailthru_category": "shoes"
    },
    "image": "http://example.com/images/stock/high_heels.jpg"
  }, {
    "qty": 1,
    "title": "Men's Shoes in Black",
    "id":"SKU1001",
    "url": "http://example.com/products/mens-shoes-in-black",
    "price": 19999,
    "tags": ["shoes", "footwear", "formalwear", "mens", "color-black"],
    "vars": {
      "sailthru_category": "shoes"
    },
    "image": "http://example.com/stock/black_mens_shoes.jpg"
  }],
  "vars": {
    "order_level_var": "shoes_purchase"
  },
  "adjustments": [{
    "price": 2500,
    "title": "Express Shipping"
  }]
}

{
    "job":,
    "report_email":"example@sailthru.com"
}

{
    "job":,
    "postback_url":"https://www.example.com/service/job-result"
}