How can we help?

New post
1

POST/PUSH JSON to a KLIP data source

Avatar
Martin Bornesjö
None
Follow

Hi,

I would love to see a data source for incoming JSON. Exactly the same function you have today where I can upload a JSON formatted file but I would love to post directly to it by RESTful requests.

This would let me, for example to use extensions in Zendesk and connect them to triggers. So every time that the Zendesk trigger is activated, Zendesk will send a JSON PUSH or PUT request directly to the data source in Klips. Then I can build a KLIP that is directly updated by Zendesk

A BIG plus point would also be if the request could have an option named "append". That would append the new value to the data source without deleting the old value. Then we could for example say that the data source accept a maximum of 300 updates. When 301 comes the oldest one is pushed out(round robin). Then I could also make historical views of any trigged event I want without being limited to Zendesk API. 

That would be awesome! 

Date Votes

3 comments

  • 0
    Avatar
    James Pardue

    This is exactly what I need as well.  We have custom monitoring software which aggregates across DB, logs, etc. and applies some business logic.  It can push data out but we don't currently have a webserver wrapped around it.  I could spend some time adding a quick web interface but then we'd need inbound ports to be opened on each of those servers which isn't going to happen.

    Please let me know if something like this gets created because we could really use it!

  • 1
    Avatar
    Nikta Kanuka

    Hi Martin and James,

    Thanks for sharing this feedback! I can definitely see how pushing JSON data and appending it to a data source would be useful in a dashboard. I'll be sure to pass this along to the product team.

    In the meantime, I think you will be able to get the desired outcome by using a service like Zapier, IFTTT, or Google Scripts in conjunction with Google Sheets or Dropbox. The flow would basically be:

    Action happens in Zendesk
    Zapier/IFTTT/Google Script trigger goes off and appends the JSON data to a Google Sheet
    Klipfolio data source refreshes (as often as appropriate) and pulls in new data into the Klip.

    This is a bit more work to set-up and requires external tools, but should get the job done. Let us know if you try it out, and don't hesitate to reach out to support@klipfolio.com if you have questions.

     

  • 0
    Avatar
    Meggan King

    Hi Everyone,

    This post is a little old, but it is possible to push raw data to a JSON data source using our PUT command. Our example shows pushing a file, but it is also possible to just push the data itself:
    https://apidocs.klipfolio.com/reference#section-put-datasource-instancesiddata

    PUT https://app.klipfolio.com/api/1.0/datasource-instances/{id}/data


    This will overwrite all the data in the data source - it will not append, so make sure the data you are pushing is complete for the time range you wish to update. 

    This can also be used to push CSV data as well. 

    Thanks

    Meggan

Please sign in to leave a comment.