1. List Rows
  2. Create Row
  3. Update Row
  4. Delete Row

/rows

List Rows

URL:  /tables/{name}/rows 

Method: GET

Protocol: HTTP, HTTPS

Parameters:

  • name – table name

Returns one of:

  • 200 (OK) + collection of rows
  • 404 (Not Found)

Example:

$ curl -X GET http://api.giscloud.com/1/tables/mytable/rows

<rows total="2" page="1">
    <script id="tinyhippos-injected"/>
    <row>
        <wkb_geometry>0101000020E6100000F6FFFFBF0E4E50C0253FCDBF1D733AC0</wkb_geometry>
        <ogc_fid>1</ogc_fid>
        <__created>2014-09-26 13:17:04</__created>
        <__modified>2014-09-26 13:17:04</__modified>
        <__owner>2</__owner>
        <name>myFirstNickname</name>
        <myname>myFirstName</myname>
    </row>
    <row>
        <wkb_geometry>0101000020E6100000F5FFFFAF3B4F50C0E51BFBE7BE733AC0</wkb_geometry>
        <ogc_fid>2</ogc_fid>
        <__created>2014-09-26 13:36:14</__created>
        <__modified>2014-09-26 13:36:14</__modified>
        <__owner>2</__owner>
        <name>mySecondNickname</name>
        <myname/>
    </row>
</rows>

You can also chose format of geometry column using geometry parameter. Geometry parameter can be “false”, “wkt” or “wkb”.

Example:

$ curl -X GET http://api.giscloud.com/1/tables/mytable/rows?geometry=false

<rows total="2" page="1">
    <script id="tinyhippos-injected"/>
    <row>
        <wkb_geometry/>
        <ogc_fid>1</ogc_fid>
        <__created>2014-09-26 13:17:04</__created>
        <__modified>2014-09-26 13:17:04</__modified>
        <__owner>2</__owner>
        <name>myFirstNickname</name>
        <myname>myFirstName</myname>
    </row>
    ...
</rows>


$ curl -X GET http://api.giscloud.com/1/tables/mytable/rows?geometry=wkt

<rows total="2" page="1">
    <script id="tinyhippos-injected"/>
    <row>
        <wkb_geometry>POINT(-65.2196502685545 -26.4496726871577)</wkb_geometry>
        <ogc_fid>1</ogc_fid>
        <__created>2014-09-26 13:17:04</__created>
        <__modified>2014-09-26 13:17:04</__modified>
        <__owner>2</__owner>
        <name>myFirstNickname</name>
        <myname>myFirstName</myname>
    </row>
    ...
</rows>


$ curl -X GET http://api.giscloud.com/1/tables/mytable/rows?geometry=wkb

<rows total="2" page="1">
    <script id="tinyhippos-injected"/>
    <row>
        <wkb_geometry>0101000020E6100000F6FFFFBF0E4E50C0253FCDBF1D733AC0</wkb_geometry>
        <ogc_fid>1</ogc_fid>
        <__created>2014-09-26 13:17:04</__created>
        <__modified>2014-09-26 13:17:04</__modified>
        <__owner>2</__owner>
        <name>myFirstNickname</name>
        <myname>myFirstName</myname>
    </row>
    ...
</rows>

Create Row

URL:  /tables/{name}/rows 

Method: POST

Protocol: HTTPS

Parameters:

  • name – table name

Returns:

  • 201

Example:

curl -X POST https://api.giscloud.com/1/tables/mytable/rows

Update Row

URL:  /tables/{name}/rows/{id} 

Method: POST

Protocol: HTTPS

Parameters:

  • name – table name
  • id – row id

Returns:

  • 204 if successful
  • 404 if the resource wasn’t found

Example:

curl -X POST https://api.giscloud.com/1/tables/mytable/rows/1

Delete Row

URL:  /tables/{name}/rows/{id} 

Method: DELETE

Protocol: HTTPS

Parameters:

  • name – table name
  • id – row to be deleted

Example:

curl -X DELETE https://api.giscloud.com/1/tables/mytable/rows/1

Returns one of:

  • 204 if successful
  • 404 if the resource wasn’t found