I am using SSMS v18.12.1, and am trying to write a T-SQL query to extract specific values from multiple columns, and at times nested values. In the example below, I would like to extract the DeliverySchedule @Type value, and the…
I'm confused to merge array contents from JavaScript. Please help to get the best way to get desired result. A i also have tried other ways referred on SO. [ { "Afghanistan": 2646432, "categories": "2018" }, { "Afghanistan": 6545700, "categories":…
Here i have Array of objects, in this agents array has 0 elements. i have add an object to this. "agents": [{}] in this i want to add below element: { "refURL": "/unifiedconfig/config/agentteam/5020", "changeStamp": 18, "agentCount": 0, "description": "Cumulus All…
I have create the json file from the sql table but the output is not same with the output i expected. Below is my code to create the json file from the sql table <?php include 'config.php'; $sql = "SELECT…
I'm trying to implement a categories input with this data returned from my DB [ { _id: '63e59f91bd2a21368188ff4b', title: 'Uncategorized', slug: 'uncategorized', categoryType: 'blog', createdAt: '2023-02-10T01:36:17.704Z', updatedAt: '2023-02-10T01:36:17.704Z', }, { _id: '63e5984028745af5bad2c015', parentCategory: { _id: '63e5974a786719dd4bb2d37b', title: 'Projects', }, title:…
I am validating a json file, I need to validate in a field that if it is null, assign a default value, I can't find how to perform a validation with if conditional file.json { "timeout": 100 } jq -r…
I am converting several .NET Core 6 web services to AWS Lambda functions. I have completed eight so far with no issues, except for this one. I am trying to test it from Visual Studio using the mock lambda tool.…
My problem in javascript is that I want specific elements in this case location.name to be thrown into change / array so that they don't repeat [Las "Żółta Górka", Park Wodziczki Poznań, Sala SP 5, Rzeszów]. My json api https://apidemo.outrainer.pl/firms/1/trainings?future=14&past=7…
I have a JSON, and I want to loop through it but when i loop through it, due to the strings present with it, the loop is failing. How do i just loop through the objects in the JSON ?…
Here is my pd.DataFrame with its metadata column: date metadata 0 2022-12-03 [{'key': 'key1', 'value': value0.1'}, {'key': 'key2', 'value': value0.2'}, {'key': 'key3', 'value': value0.3'}] 1 2022-12-07 [{'key': 'key1', 'value': value1.1'}, {'key': 'key2', 'value': value1.2'}, {'key': 'key3', 'value': value1.3'}] 2 2022-12-02…