I have a PostgreSQL database with a JSONB column named properties. I'm trying to create a query that matches all elements with a value inside properties that matches a certain value. Currently, I'm using a combination of jsonb_path_exists and like_regex,…
To give you some context: I am trying to implement a simple Crud with a Client/Server architecture. While doing so I tried making a multi-step form, since a lot of the forms became quite long. But, I soon realized error…
I've got a Rest endpoint that receives the class EntityInsertRequest public class EntityInsertRequest { public string Description { get; set; } public IEnumerable<EntityFieldInsertRequest> Fields { get; set; } } public class EntityFieldInsertRequest { public string DatabaseField { get; set; }…
I have a table similar to this, where I need to pull the value out of each JSON field that has an id equal to 2. I've tried multiple examples, but cannot manage to wrap my head around how to…
I have a json (not jsonb) column in a PostgreSQL (version 13.12) table from which I want to remove specific values of an array attribute. For example, in the following table (db-fiddle) I want to remove all occurrences of "D"…
I am trying to remove all indentation from my json : "date": { "start": "2020-10-23T15:30:00+00:00" } I tried with this var freeContent = JsonConvert.SerializeObject(JsonConvert.DeserializeObject(content)); But I got "date": {"start": "2020-10-23T13:30:00+00:00"} As you can see, the date is modified while I…
I have the following json output { "secrets": [ [ "{", " "name": "testSecret",", " "vault-apikey": "kv",", " "vault-value": "sabrinaTest"", "}" ] ] } But I need the output to be a little cleaner and look like this: { "secrets":…
I am trying to adapt the following JSON with jolt [ { "id": "abc", "colour": "black | orange | anthracite", "material": "polyester | aluminium | v2a | steel", "temp min": "45 °C", "temp max": "-35 °C", "category": "rope", "length": "18…
I am getting RuntimeError: no validator found for <class 'langchain_community.tools.json.tool.JsonSpec'>, see arbitrary_types_allowed in Config even after to installing import yaml from langchain_community.agent_toolkits import JsonToolkit, create_json_agent from langchain_community.tools.json.tool import JsonSpec from langchain_openai import OpenAI
I have three scenarios: Scenario 1: When Fee1 has a value and Fee2 is "", output attribute FinalFee should have Fee1 value Scenario 2: When Fee1 is "" and Fee2 has a value, output attribute FinalFee should have Fee2 value…