skip to Main Content

Converting JSON output from API pull to pandas Dataframe?

I am using an API pull to extract data from the AESO API in python. My code is as follows: API_KEY = 'api_key_here' merit_order_url = 'https://api.aeso.ca/report/v1/meteredvolume/details?startDate=2022-01-01' url = merit_order_url headers = {'accept': 'application/json', 'X-API-Key': API_KEY} response = requests.get(url, headers=headers) The…

VIEW QUESTION

Amazon web services – how to set interval in lambda start job

I have lambda that stops a running job and start a different glue job. It goes like this: def lambda_handler(event, context): client = boto3.client('glue') body = json.loads(event['body']) job_id_to_stop = body['job_id_to_stop'] job_to_start_argument = body['job_to_start_argument'] client.batch_stop_job_run( #STOP JOB RUN JobName='job-to-stop', JobRunIds=[ job_id_to_stop…

VIEW QUESTION

convert nested Json to multiple Csv files

I have a json pull using api and below is what the file looks like: [ { "id": 181, "emp_number": "527", "clock_id": "124", "organization_trackings": [ { "title": "Division", "value": "200", "value_description": "Cons" }, { "title": "Location", "value": "951", "value_description": "Jasp"…

VIEW QUESTION
Back To Top
Search