Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

How do I Import data from an api?

How do I Import data from an api?
I want to access data from the Bristol API (open transport data). How do I do this?
0 Kudos
1 Reply

Hi Nigel, 

For such custom data integration You can create a custom python recipe (with no input dataset  which structure would look like this 

import dataiku
import pandas as pd, numpy as np
import requests


response = requests.get('',
headers={"X-Api-Key": api_key}
jsonResp = response.json()

output_dataframe = pd.DataFrame(jsonResp.get("data"))

py_recipe_output = dataiku.Dataset("outputDataset")


You may have to ajust the code depending on what you want to do but dont hesitate to  check DSS API Documentation  especially if you choose to use a different language. 

0 Kudos


Labels (2)
A banner prompting to get Dataiku