Working with JSON

To convert JSON into readable date to be used in Excel I suggest downloading and install Microsoft Power Query Add-in, It's a really powerful tool that can read and convert JSON data straight into Excel.

Download link: https://www.microsoft.com/en-gb/download/details.aspx?id=39379 

Any suggestions for importing the JSON.  I was able to create the JSON to get the data (articles from sandbox), but it didn't pull any of the pictures. How do I get the pictures using curl to create the JSON.

I am am unable to load the JSON I created. (I do know the correct domain and credentials in the command)

curl https://mydomain.zendesk.com/api/v2/help_center/sections/360022690834/articles.json ^
-d '{"article": {"title": "Taking photos in low light", "body": "Use a tripod", "locale": "en-us" }, "notify_subscribers": false}' ^
-v -u stassa@mydomain.com:mypassword -X POST -H "Content-Type: application/json"

We are trying to use API to bring in tickets from a partner system.  The lack of line breaks makes the ticket description almost unusable.  Is there a way to make the JSON pretty in Zendesk?

EDIT: I found that we can use "html_body" in place of "body" to send formatted comment text through the API

I can send a perfectly formatted JSON from a python script, receive an HTML 201 response status but the JSON data is not processed.  When I change the JSON by force to use double-quotes rather than single-quotes and issue the same API call, I get the desired result.  

There seems to be an absolute insistence by the API to use double-quotes in JSON rather than the default single-quotes.  Can you confirm this?  Thanks in advance.

Yes, that's the best course. Thanks for posting that follow-up Allison.

Hi Jonah,

Double quotes are required in JSON for strings. From json.org: "A value can be a string in double quotes, or a number, or true or false or null, or an object or an array. "

Charles

Hi Jonah,

The easiest way is to use the Python JSON library to convert Python dictionaries to JSON objects before sending them off in your API requests. See https://docs.python.org/3.7/library/json.html. Example:

import json
my_json = json.dumps(['foo', {'bar': ('baz', None, 1.0, 2)}])
# my_json is ["foo", {"bar": ["baz", null, 1.0, 2]}]

Thank you, Charles.

Thank you for your prompt reply.  I had a fun time taking an existing Python dictionary (which defaults to single-quotes in Python) and manipulating it sufficiently so that ZD API would ingest it successfully and not treat it as a null payload.

Best, Regards
Jonah

@allison15 Thank you so much for the tip about "html body" I was pulling my hair out trying to get the formatting to work with with the api.