I've been trying to look up guides and not sure what to do here. I have a large TXT file that I need to convert to JSON. But depending on the first 3 characters of a line different rules apply…
I have the following dictionary: {'expert_interests': "['Machine learning', 'deep learning']"} As you can see the the value of the key "expert_interests" is the String "['Machine learning', 'deep learning']". I want to convert this string value into a nested dictionary such…
Need a recommendation on how to handle this. I have a python lambda function that accepts in json. There could be 10 different types of payload. For example: { "animalType": "dog", "name": "josie", ... } another app can send in:…
I want to find the best way to perform a server-side query to find JSON documents by some initial query criteria, then grouping all these documents by some field in the document and then reducing each group to only contain…
I have a table with a record that has JSON content and it is an array with no name. Sample data looks like this: carId carType parts Z003 Company [{"Value":"New","Type":"Brakes","Code":"D"},{"Value":"Upgraded","Type":"Doors","Code":"E1"}] Z003 Company [{"Value":null,"Type":"Brakes","Code":"D"},{"Value":null,"Type":"Doors","Code":"E1"}] Z003 Company [{"Value":"USed","Type":"Brakes","Code":"D"},{"Value":"New","Type":"Tires","Code":"G7"}] There are actually about…
I've a Java object structure corresponding to following JSON: { "parentClass": { "parentField1": "parentFieldValue1", "parentField2": "parentFieldValue2", "childClass": { "childField1": "childFieldValue1", "childField2": "childFieldValue2" }, "childClassList": [ { "stringField": "stringField1", "integerField": "integerField1" }, { "stringField": "stringField2", "integerField": "integerField2" } ] } }…
I'm trying to call a response from an API. I'm not sure what is wrong, maybe the response isn't valid JSON but I'm not sure. It doesn't seem the json module is initialising either. I've managed to call the data…
So i have to tables i would like to join but get an error. The tables look like this. patterns table: patternUuid urlName title 1b3d8a0f-2bc3-4c50-a00a-6cf99335dd20 card-fraud Credit Card Fraud 04bdcd7b-d61b-45cc-b9ea-c2decc77c852 return-policy-fraud Return Policy Fraud members table: id memberId patternsUuid 1…
I am trying to read a JSON file in powerBI whose data looks like this, But when I expend the column timeseries.data, I can only see 'timestamp' column instead of 'timestamp' and 'average' "cost": 44639, "timespan": "2023-02-10T23:59:59Z/2023-03-13T23:59:59Z", "interval": "PT1H", "value":…
I have this JSON response, I want to unflatten it, but every possible unflatten library just append it to array, I want to highlight to have 3 object like shown, is there any easier way? { "highlights.id": ["9ab80883-e8eb-4710-9818-e476fc32e356", "824ff2a0-1f17-44b7-b99f-ce227af12ea7", "4a9e35c5-e03f-41d6-a4b5-635b08bc1bbe",…