json

How to I deal with '[' and ']' json characters in snowflake?

I'm using snowflake. This is my statement: select PARSE_JSON(src): "eventType"::STRING AS eventtype, PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events" AS events, PARSE_JSON(PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events"): "actor" AS actor, PARSE_JSON(PARSE_JSON(PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events"): "actor"): "actor" AS actor2, PARSE_JSON(PARSE_JSON(PARSE_JSON(src): "data"::STRING): "events"): "client" AS client, * from stage.okta_events This…

VIEW QUESTION

Perl getting json values

Got some problems to access json values (translated from xml). for my $PORT (0..$#PORTS) { print Dumper $PORTS[$PORT]->{'neighbor'}; if (defined($PORTS[$PORT]->{'neighbor'}->{'wwn'}->{'$t'})) { print Dumper @{$PORTS[$PORT]->{'neighbor'}->{'wwn'}->{$t}}; } else { print Dumper "not defined" } } Test works when $PORTS[$PORT]->{'neighbor'} is empty but…

VIEW QUESTION

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
Back To Top
Search