I'm biggest on Powershell working in Windows and looping through spreadsheets perform mundane tasks. Loading info to SQL, sending emails, etc.
"Powershell" didn't return much in the Zendesk community support so when I hit this combination that functioned, maybe it's of use to you.
This line ran through a Powershell ISE -
curl.exe https://myZen.zendesk.com/api/v2/tickets.json -d "@\\my\path\to\the\JSON\text.file" -u "myEmail@myDomain.com/token:1a2b3c4d5e6f7g8h9i0kMyToken" -X POST -H "Content-Type:Application/JSON"
Where \\my\path\to\the\JSON\text.file contains the JSON built from parsing a spreadsheet with the appropriate fields -
<
{
"ticket": {
"requestor": {"name": "YourName Here"},
"email": "myEmail@myDomain.com",
"submitter_id": 12345678986754321,
"subject": "My ticket created by a Powershell cURL execution.",
"comment": {"body": "Created this ticket"},
"assignee_email": "myEmail@myDomain.com",
"status":"hold",
"custom_fields":[{"id":1500004819162,"value":"Recurring"},
{"id":1500012399961,"value":"Normal"}]
}
}
>
Where we created the custom fields representing a ticket type and severity value.
This darn thing created tickets for me.
