How to obtain a data source's configuration settings as XML?

How to obtain a data source's configuration settings as XML?

The /services/webservices/system/admin/resource/operations/getResource Web API call may be used to retrieve data source configuration settings.

1. Set the value of Studio >> Administration >> Configuration >> Studio >> Data >> XML Text Size to a large size (e.g. 50000). This is to accommodate the length of the result returned by the call.
 
       

2. Run /services/webservices/system/admin/resource/operations/getResource.

3. In the input XML field, specify the full pathname of the data source.

Example

If the full pathname of the data source is /shared/DATA_SOURCES/test_datasource, then the input XML would be:

<resource:getResource xmlns:resource="http://www.compositesw.com/services/system/admin/resource" xmlns:common="http://www.compositesw.com/services/system/util/common">
  <resource:path> /shared/DATA_SOURCES/test_datasource</resource:path>
  <resource:type>DATA_SOURCE</resource:type>
  <resource:detail>FULL</resource:detail>
</resource:getResource>
  
       

4. Click the Okay button.

5. A results panel will appear in Studio. Click on the Details button in the panel. A dialog box will pop up displaying the configuration settings.

     

Note: If getResource fails with the following error, it means that the value of  XML Text Size needs to be increased. 

---------------------
One or more errors were encountered while parsing the result:
XML document structures must start and end within the same entity.
Please check 'XML Text Size' configuration if the result was truncated
---------------------