List the tables and fields in a XML or JSON file for a folder connection

Overview

List the tables and fields of a XML file or from a JSON file, for a folder connection by using the GetFileTablesEx method.

Example

The type of the connection is folder and the identifier of the connection is C28CBBA8-83B63E70-FA9E784E-BB58CD3B-B72BFAF8.

The name of the file is Cities.xml.

The client sends:

{ "jsonrpc": "2.0", "id": 6, "method": "GetFileTablesEx", "handle": 1, "params": [ "C28CBBA8-83B63E70-FA9E784E-BB58CD3B-B72BFAF8", "Util/Cities.xml", { "qType": "XML" } ] }

The engine returns:

{ "jsonrpc": "2.0", "id": 6, "result": { "qTables": [ { "qName": "catalog/city", "qFields": [ { "qName": "id" }, { "qName": "name" }, { "qName": "size" }, { "qName": "country" }, { "qName": "language" } ], "qFormatSpec": "(XmlSimple, table is [catalog/city])" } ] } }

The table catalog/city contains five fields: id, name, size, country and language.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here