JSON Dynamic Body

I liked the JSON OAuth connector also, but dislike the speed. I found that using a different method with Jupyter notebooks and Python, I have more flexibility talking to my APIs and my speed is significantly faster.

The requests library is a popular choice for making API calls in Python, and it’s what I would typically use in most environments. However, when working within Domo's Python script task, the standard library might be more limited.

If requests isn't available directly in Domo, you can achieve similar functionality using the http.client module or even urllib from Python's standard library, which can handle HTTP requests fairly well, although with a bit more boilerplate code compared to requests.

import http.client

import json


conn = http.client.HTTPSConnection("api.example.com")


headers = {

    'Content-Type': "application/json",

    'Authorization': "Bearer your_access_token"

}


body = json.dumps({

    "dynamic_param_1": "value1",

    "dynamic_param_2": "value2"

})


conn.request("POST", "/your/api/endpoint", body, headers)


res = conn.getresponse()

data = res.read()


print(data.decode("utf-8"))

If you decide to go the Jupyter notebook route, you might also look into pandas for managing data and requests for more straightforward API calls. This combination offers speed and flexibility, making it a powerful alternative to using connectors directly in Domo.