รายจ่ายกรุงเทพมหานคร

Create

Update / Insert

Query

Query (via SQL)

Query example (first 5 results)

Query example (results containing 'jones')

Query example (via SQL statement)

A simple ajax (JSONP) request to the data API using jQuery

                                var data = {
                                  resource_id: '3475f3d7-eac7-4ae4-9010-1915cbddc2e4', // the resource id
                                  limit: 5, // get 5 results
                                  q: 'jones' // query for 'jones'
                                };
                                $.ajax({
                                  url: 'https://data.bangkok.go.th/en/api/3/action/datastore_search',
                                  data: data,
                                  dataType: 'jsonp',
                                  success: function(data) {
                                    alert('Total results found: ' + data.result.total)
                                  }
                                });
                              

Example: Python

                                import urllib

                                url = 'https://data.bangkok.go.th/en/api/3/action/datastore_search?limit=5&resource_id=3475f3d7-eac7-4ae4-9010-1915cbddc2e4&q=title:jones'  
                                fileobj = urllib.urlopen(url)
                                print fileobj.read()