Create a new list
|
1 |
POST /api/1/list |
Parameters
| Name | Parameter Type |
Allow Multiple |
Required/ Optional |
Data Type | Description |
|---|---|---|---|---|---|
| Authorization: | Header | false | required | String (Bearer {access token}) | Pass the authentication token that was granted when you authorized access. |
| listname | form | false | required | string | The list name to display in the UI. |
| foldername | form | false | optional | string | Name of folder that contains the list. If left blank, the list goes into the Default Folder. If the folder does not exist it will be created. |
| headings | form | false | Optional | String | "Y" or "N" for if the first row of the file are headings. Default value is "Y". Any non-null value other than "Y" will be treated as "N". |
| fieldseparator | form | false | Optional | String ("COMMA", "TAB", "SEMI") | Character used around fields--valid values: "COMMA", "TAB", "SEMI". If not specified then the field separator value is determined by inspecting the file upload data. |
| uploadspecs | form | false | required | String | When creating a new list, uploadSpecs is used to describe the structure of the list you are creating in Act-On.* |
| file | Body | false | optional | File | The file to upload (in CSV format). |
| quotecharacter | form | false | required | String ("NONE", "SINGLE_QUOTE", "DOUBLE_QUOTE") | Specify the type of quotes used around field names. Valid values: "NONE", "SINGLE_QUOTE", "DOUBLE_QUOTE" |
*Note: See uploadspecs
Request
Following are example requests:
HTTP
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
POST /api/1/list HTTP/1.1 Host: restapi.actonsoftware.com Authorization: Bearer 781137c426b2db9fb0fe137fb6ffde79 Cache-Control: no-cache Content-Type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="listname" New List ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="foldername" New Folder ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="headings" Y ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="fieldseperator" COMMA ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="quotecharacter" DOUBLE_QUOTE ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="uploadspecs" [{"columnHeading": "E-mail Address", "ignoreColumn": "N", "columnType": "EMAIL", "columnIndex": "0"}, {"columnHeading": "First Name", "ignoreColumn": "N", "columnType": "FIRSTNAME", "columnIndex": "1"}, {"columnHeading": "Last Name", "ignoreColumn": "N", "columnType": "LASTNAME", "columnIndex": "2"},{"columnHeading": "Company", "ignoreColumn": "N", "columnType": "COMPANY", "columnIndex": "3"}] ----WebKitFormBoundary7MA4YWxkTrZu0gW Content-Disposition: form-data; name="file"; filename="API Test Upload.csv" Content-Type: application/vnd.ms-excel ----WebKitFormBoundary7MA4YWxkTrZu0gW |
curl
|
1 |
curl -X POST -H "Authorization: Bearer 863d23455dfb499ded19d17d5af19fc4" -H "Cache-Control: no-cache" -H "Content-Type: multipart/form-data" -F "listname=Test List" -F "headings=Y" -F "fieldseperator=COMMA" -F "quotecharacter=NONE" -F "uploadspecs=[{"columnHeading": "E-mail Address", "ignoreColumn": "N", "columnType": "EMAIL", "columnIndex": "0"}, {"columnHeading": "First Name", "ignoreColumn": "N", "columnType": "FIRSTNAME", "columnIndex": "1"}, {"columnHeading": "Last Name", "ignoreColumn": "N", "columnType": "LASTNAME", "columnIndex": "2"},{"columnHeading": "Company", "ignoreColumn": "N", "columnType": "COMPANY", "columnIndex": "3"}]" -F "file=@/path/to/file.csv" "https://restapi.actonsoftware.com/api/1/list" |
Response
A successful request results in an HTTP 200 response with a JSON object with the list listing.
An example JSON response:
|
1 2 3 4 5 |
{ "status": "success", "message": "Upload completed", "jobId": "8167376" } |
When you use a file upload to create a list, the job id is returned. To get the upload status, send a request using this job id:
|
1 |
GET /api/1/list/{jobid}/status |
This returns a JSON object similar to the following. If the list was uploaded successfully, the list id is returned along with the number of appended, updated, failed and rejected records.
|
1 2 3 4 |
{ status: "success" jobDetails: "{"status":"ok","listId":"l-7662","appendCount":4,"updateCount":0,"failedCount":0,"rejectedCount":0}" } |
If you do not include a file in your POST request, an empty list is created and the list id is returned.
|
1 2 3 4 5 |
{ "listId": "l-0c87", "status": "success", "message": "List created" } |
