Why JSON response is not getting parsed? – Ios swift
I am making an API call with URLSession and I am getting the error like: The data couldn’t be read because it isn’t in the correct format I don't know why it is happeing. Even I am able to print…
Postgresql – SQL Function to turn JSON keys into Attribute columns
I have a JSON_TEXT column in my PostgreSQL DB such as this {'a':'one', 'b':'two', 'c':'three'} I would like to create a function that would loop through all of the DISTINCT JSON_object_keys and create a column for each of the keys,…
Search in JSON with PHP
I want to search inside a JSON file with the following format: { "success": true, "msg": "", "obj": [ { "id": 1, "up": 546636462, "down": 4172830061, "total": 53687091200, "name": "حامد ", "enable": true, "expiryTime": 1667049201686, "listen": "", "dork": 23050, "net":…
How to check JSON String based on another JSON String? – PHP
I'd like to do a loop with these JSON strings. $json_m = '[ {"name":"1","value":"1"}, {"name":"2","value":"2"}, {"name":"3","value":"3"}, {"name":"4","value":"4"}, {"name":"5","value":"5"}, ]'; $json_a = '[ {"name":"1-m","value":"1"}, {"name":"2-m","value":"3"}, {"name":"3-m","value":"5"}, ]'; I do a loop and on $json_m. If the value exists in both JSON,…
get rid of numbers in json response (LARAVEL 8)
my function in a controller is here below public function getStudentsinGrade($grade, $school_id){ $students = Student::where('school_id', $school_id)->get(); $this -> grade = $grade; $gradeStudent= $students->filter(function($value,$key){ return $value->grade == $this->grade; }); if(count($gradeStudent) > 0){ return response()->json($gradeStudent); } else{ return response('No Registered Student'); }…
Mongodb – How do I constrain my query in mongo, where I need a conditional join on the results
I have a large collection of JSON documents that has many entries of the following format (contents in my example are important to my question): doc1 { "data": [{ "entry": { "fieldA": "aaa", "fieldB": "xxx" } }, { "entry": {…
Can't get basic remote API value shown in PHP
This is my code, where I am trying to show the values from the remote API which I am trying to fetch via a .php file in Wordpress. <?php try { $response = wp_remote_get( 'MYURLHERE', array( 'headers' => array( 'Accept'…
Mysql – how to get multiple data with same user id from a table in nest js? suppose i have a user table .how can I get user id matched data?
How do I get multiple data with same user id from a table in nestjs? suppose I have a user table. How can I get user id matched data? import { Injectable } from '@nestjs/common'; import { InjectRepository } from…
How can I extract a number from string using regex with various formats (MySQL)?
I have a MySQL data table which stores metadata for client transactions. I am writing a query to extract a number out of the metadata column, which is essentially a JSON stored as a string. I am trying to find…
Azure data factory – replace json rn
I have an API response which contains rn. I am not able to replace it by using replace(string, 'rn', ''). It does not work for it. When I use replace(string, 'r', '') it replaced every word which contains r except…