I'm trying to ingest data from the open-source, public Yahoo Finance API using Azure Data Factory. The endpoint I'm testing is https://query2.finance.yahoo.com/v8/finance/chart/GOLD. I am able to ingest the data but I'm coming up with an issue when trying to transform…
I'm trying to grab data from my response in Bruno and set it to the environment variable called bearer_token. Here's the issue. The response is raw and is just the bearer token. So, I'm not sure what I'm supposed to…
I have the following input JSON value : { "A": { "B": [ { "tempName": "rq3ewas", "name": "test1" }, { "tempName": "", "name": "test2" }, { "tempName": null, "name": "test3" }, { "tempName": "test4" } ] } } and want…
In my Angular program, have a class called myObj and an array called myArrayObj, that contains many instances of myObj. I am currently storing it into Blob and write into file, as shown below. const blob = new Blob([JSON.stringify([myArrayObj])], {…
I used to be a jq masochist, but I discovered mlr, which seems to offer the opportunity for more (yet different) pain. I found a nice web site that allows me to issue curl commands without API keys, etc., to…
I'm beginner in Groovy, I do JSON parsing and export data to a csv file, but it turns out like in the screenshot. How can I better write it in the code so that the data is correct when exporting…
I am setting up variable validation for Kafka topic schemas for a Terraform module I am creating. The schemas can be one of two types: AVRO or JSON. As both schema types are defined in a .json file, I use…
I have a need to convert some json to xml and then back to json ideally preserving the structure. I've gotten quite close but I can't find a way to use dicttoxml/xmltodict to not end up with each list of…
I want to iterate through a JSON file of this kind, using C#, and compare if the response is the same as the expected response. Json file: { "request": "AAA", "response": "BBB", "expected_response": "BBB" }{ "request": "CCC", "response": "DDD", "expected_response":…
I am trying to query a table in Snowflake that is built with a single field labeled "Value" and each row is a separate JSON object. Row 1: { "artist": { "artistID": "artist_1", "artistName": "Roblox" }, "descriptors": { "styles": […