I have a json string. Like this: "{"http_requests":[{"http_requests":{"code":"400","method":"PUT","value":89}},{"http_requests":{"code":"200","method":"PUT","value":45}}]}" I want to insert this json to mongodb. But I have error in my code. The error is "cannot transform type string to a BSON Document: WriteString can only write while positioned…
I have a table A and in it I have a column of type json that receives an array of dates. I need to fetch all female records from table A. I need to return a specific date from each…
I'm trying to get Tradingview signals to my remote php script using webhook and trading view alerts. I can't succeed . I'm following this way In my trading view strategy I have this strategy.entry("Long", strategy.long, alert_message = "entry_long") strategy.exit("Exit Long",…
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…
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,…
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":…
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,…
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'); }…
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": {…
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'…