API requests

Connect to your data APIs to GET, POST, etc. Supported via the standard Python Requests library. This simple example shows how to get your data from request to Pandas DataFrame.

Code explained in-depth on the Python data ingestion page.

import requests
import pandas as pd

# GET request 
response = requests.get('your_API_url_goes_here')

# return the API response to the sheet 
df = pd.DataFrame(response.json())