Tags » JSON

Web scraping with python for ESRI integration

GeoJSON data is available from ramm.com about our cities bridges. To make it available for our engineers it needs to loaded to a local database. There are lots of metrics stored there too which can change daily, so we need to do this every night. 1,056 more words


JSON Flattening Part 1 - The JSONFlatten function

This article presents an approach to flatten out a JSON structure into an “Edge” table.
That’s something I’ve been exploring multiple times in the past for XML data, see for example : … 1,364 more words


ESP32: Sending JSON messages over MQTT

The objective of this post is to explain how to send JSON messages over MQTT using the ESP32. 1,520 more words


ESP32: Creating JSON messages

The objective of this post is to explain how to create JSON formatted messages using the ArduinoJson library and the ESP32. 832 more words


SQL for JSON Rationalization Part 15: Cartesian Product and Projection

In part 14 of this blog series Cartesian Product queries were discussed that did have an Asterisk projection; this blog discusses specific paths as projection (non-Asterisk). 512 more words


Calling Untrusted SSL HTTPS request using HttpClient give "Message=The remote certificate is invalid according to the validation procedure"


+You want to deploy web application server (for example ASP.NET Web API) which require SSL certificate and HTTPS

+You want to make a call to that server using HttpClient… 204 more words

Microsoft Technology


1. Create a simple ASP.NET Web API project with HTTP GET and POST method

Create a simple Web API Controller like this:

    public class ValuesController : ApiController
        string[] list = new string[] { "value1", "value2" };
        // GET api/values
        public IEnumerable<string> Get() { return list; }

        // GET api/values/1
        public string Get(int id) { return list; }

        // POST api/values
        public string Post(string value) { return value; }
… 345 more words
Microsoft Technology