Dataiku DSS 7 AMA is live! Learn more

How do I Import data from an api?

Dataiker
Dataiker
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
Dataiker
Dataiker

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


api_key="YOUR_API_KEY"

response = requests.get('https://bristol.api.urbanthings.io/api/2.0/static/transit/stops',
headers={"X-Api-Key": api_key}
)
jsonResp = response.json()


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

py_recipe_output = dataiku.Dataset("outputDataset")

py_recipe_output.write_with_schema(output_dataframe)


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)