code: def get_connection(connection_id, deep=False):
      
      url = os.path.join(settings.HEROKU_CONNECT_API_ENDPOINT, 'connections', connection_id)
      payload = {'deep': deep}
      response = requests.get(url, params=payload, headers=_get_authorization_headers())
      response.raise_for_status()
      return response.json()
docs: Get Heroku Connection connection information.
  
      For more details check the link -
      https://devcenter.heroku.com/articles/heroku-connect-api#step-8-monitor-the-connection-and-mapping-status
  
      Sample response from API call is below::
  
          {
              "id": "<connection_id>",
              "name": "<app_name>",
              "resource_name": "<resource_name>",
              "schema_name": "salesforce",
              "db_key": "DATABASE_URL",
              "state": "IDLE",
              "mappings":[
                  {
                      "id": "<mapping_id>",
                      "object_name": "Account",
                      "state": "SCHEMA_CHANGED",
                      …
                  },
                  {
                      "id": "<mapping_id>",
                      "object_name": "Contact",
                      "state": "SCHEMA_CHANGED",
                      …
                  },
                  …
              ]
              …
          }
  
      Args:
          connection_id (str): ID for Heroku Connect's connection.
          deep (bool): Return information about the connection’s mappings,
              in addition to the connection itself. Defaults to ``False``.
  
      Returns:
          dict: Heroku Connection connection information.
  
      Raises:
          requests.HTTPError: If an error occurred when accessing the connection detail API.
          ValueError: If response is not a valid JSON.