json - Digital Craftsman

Digital Craftsman

Sign in Subscribe

json

A collection of 5 posts

Find JSON element in MySQL

Find JSON element in MySQL

MySQL isn't really build for searching through JSON data. PostgreSQL seems to be way better in this regard. Nether the less it is possible to search since MySQL 5.7. To do so use the MySQL function JSON_CONTAINS. In our example we have a table called client_

Validate JSON Schema array or object

Validate JSON Schema array or object

Somethings a JSON response contains attributes which (depending on the resource) might be ether and object or an array. When writing a JSON schema, you usually use just one type. But there is a way to define two options. To do this you simply have to use an array instead

Check json in php

When getting in JSON for a request you first going to need to check whether the incoming content is actually valid JSON. Unfortunately there is no PHP function for that. Here is a little utility function for it: /** * Is valid JSON * * @param string $jsonString JSON string * * @return bool */ function isValidJson(

Get data from json request with Symfony

When working with Symfony actions you can get request parameters with $request->get('parameter-name'). When working with JSON requests, you don't have this kind of convenience methods. You're going to need to convert the request into parameters first. This could be done

API Testing with Postman

There are several apps on the market to test APIs with. A quite nice one I just stubled opon is called Postman [http://www.getpostman.com]. It's first of all a Chrome extension, but it's also already available as a Chrome App and therefore as a