json schema to validate required label
Im using json schema draft-4 and I am trying to conditionally add a requirement for a required label. For any value in env labels 1/2/3 are required but if the value is sit or uat then another label, date must…
Json – Counting instances of a value using jq
I'm trying to use jq to parse the output of some tool. Specifically I'm looking for a count of various HTTP status codes in the output json. I.e. something like jq -c '. | <filter>' test.json {200: 1, 301: 1,…
Nested JSON blob in Snowflake
I'm trying to query on the following JSON Blobs in MyTable that is varchar, however, JSONBlob2 has square brackets over the curly brackets that seem to be interfering with my query: MyTable JSONBlob JSONBlob2 {"a": "12345", "b": {"c":"567", "d":"llc"} }…
Extract value from JSON array using Snowflake sql
Snowflake table has a varchar column with following JSON array as value. [{"$":6394.2,"@":"decisionMetricValue","@id":"Month 1"},{"$":6672.25,"@":"decisionMetricValue","@id":"Month 2"},{"$":5643.05,"@":"decisionMetricValue","@id":"Month 3"},{"$":5564.79,"@":"decisionMetricValue","@id":"Month 4"},{"$":6966.75,"@":"decisionMetricValue","@id":"Month 5"},{"$":7605.15,"@":"decisionMetricValue","@id":"Month 6"}] Using snowflake sql, I would like to extract data in following format. Month1,Month2,Month3,Month4,Month5,Month6 6394.2,6672.25,5643.05,5564.79,6966.75,7605.15 I was trying to implement solution https://stackoverflow.com/a/77319223/20535715…
Json – How to get index of a string in an a list
public int userCompare(String s1, int i1, String s2, int i2){ String[] alphabety = {"a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z"}; String[]…
Postgresql – Add LIMIT or ORDER BY inside json_arrayagg()
I have tables level_one_table, level_two_table, and level_three_table. level_one_table to level_two_table: one to multiple rows level_two_table to level_three_table: one to one row Goal: select them all and level_two_table rows able to use LIMIT and ORDER BY. Return data structure like below:…
slf4j and log4j2 json messages escaped
I'm using slf4j and log4j2 as the implementation. I wanted my messages (in JSON) to be logged as JSON and not escaped as Strings. Looking at the org.apache.logging.log4j.layout.template.json.resolver.MessageResolver class, I see that it should work if I remove the stringified…
Json Path To extract array element with child Filter
Hi I am looking to construct a jsonpath expression to find the array element that matches the filter on a child. Please find details below Json { "items": [ { "id": 1, "children": [ {"id": 101, "name": "Child1"}, {"id": 102,…
Parse Data from OPENJSON() to extract values
Here is my code: SELECT * FROM OPENJSON ('{"AFN":{"code":"AFN","name":"Afghan Afghani","decimal_digits":0,"name_plural":"Afghan Afghanis","rounding":0,"symbol":"Af","symbol_native":"؋"},"ALL":{"code":"ALL","name":"Albanian Lek","decimal_digits":0,"name_plural":"Albanian lekë","rounding":0,"symbol":"ALL","symbol_native":"Lek"},"AMD":{"code":"AMD","name":"Armenian Dram","decimal_digits":0,"name_plural":"Armenian drams","rounding":0,"symbol":"AMD","symbol_native":"դր."},"ANG":{"code":"ANG","name":"NL Antillean Guilder","decimal_digits":2,"name_plural":"NL Antillean Guilders","rounding":0,"symbol":"ƒ","symbol_native":"NAƒ"},"AOA":{"code":"AOA","name":"Angolan Kwanza","decimal_digits":2,"name_plural":"Angolan Kwanza","rounding":0,"symbol":"Kz","symbol_native":"Kz"},"ARS":{"code":"ARS","name":"Argentine Peso","decimal_digits":2,"name_plural":"Argentine pesos","rounding":0,"symbol":"AR$","symbol_native":"$"},"AUD":{"code":"AUD","name":"Australian Dollar","decimal_digits":2,"name_plural":"Australian dollars","rounding":0,"symbol":"AU$","symbol_native":"$"},"AWG":{"code":"AWG","name":"Aruban Florin","decimal_digits":2,"name_plural":"Aruban Florin","rounding":0,"symbol":"Afl.","symbol_native":"Afl."},"AZN":{"code":"AZN","name":"Azerbaijani Manat","decimal_digits":2,"name_plural":"Azerbaijani manats","rounding":0,"symbol":"man.","symbol_native":"ман."},"BAM":{"code":"BAM","name":"Bosnia-Herzegovina Convertible Mark","decimal_digits":2,"name_plural":"Bosnia-Herzegovina convertible marks","rounding":0,"symbol":"KM","symbol_native":"KM"},"BBD":{"code":"BBD","name":"Barbadian Dollar","decimal_digits":2,"name_plural":"Barbadian Dollars","rounding":0,"symbol":"Bds$","symbol_native":"$"},"BDT":{"code":"BDT","name":"Bangladeshi Taka","decimal_digits":2,"name_plural":"Bangladeshi takas","rounding":0,"symbol":"Tk","symbol_native":"৳"},"BGN":{"code":"BGN","name":"Bulgarian Lev","decimal_digits":2,"name_plural":"Bulgarian leva","rounding":0,"symbol":"BGN","symbol_native":"лв."},"BHD":{"code":"BHD","name":"Bahraini Dinar","decimal_digits":3,"name_plural":"Bahraini…
Php – How to get the values of this JSON
I have parsed an XML file to JSON and need the values to store in MySQL. The JSON data below contains of 'one-off' and Array data. What is the best way to catch get values with PHP? How to get…