Column Data Types query via REST API

REST
1

Is it currently possible to query a Table and the column names and data types are turned in the response?

2

Yes, it is possible:

GET https://api.backendless.com/<version>/data/<table-name>/properties

HTTP request headers:

application-id: app-id-value
secret-key: secret-key-value
Content-Type:application/json
application-type: REST
3

Thanks for the quick response!

It works very well and is exactly what I was looking for. An example of my response is:

[
{“name”:“updated”,“required”:false,“type”:“DATETIME”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:false,“isPrimaryKey”:false},
{“name”:“Column1”,“required”:false,“type”:“STRING”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:false,“isPrimaryKey”:false},
{“name”:“Column2”,“required”:false,“type”:“BOOLEAN”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:false,“isPrimaryKey”:false},
{“name”:“ownerId”,“required”:false,“type”:“STRING”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:false,“isPrimaryKey”:false},
{“name”:“objectId”,“required”:false,“type”:“STRING_ID”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:false,“isPrimaryKey”:true},
{“name”:“created”,“required”:false,“type”:“DATETIME”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:false,“isPrimaryKey”:false}
]

4

That’s correct. Please let us know if you have any questions about the data elements in the response.

Regards,
Mark