Solved

FME Server REST API: return the SDE connection string?

  • 13 August 2019
  • 2 replies
  • 4 views

Badge +8

I am using the API to generate an inventory of our server FME workspaces for an upcoming migration

Can you return an SDE connection string that isn't a published parameter?

 

Example call:

http://stdcap-koaa-001/fmerest/v3/repositories/BASISDATA/items/KLIC.fmw/datasets/destination

Response:

[  {    "format": "GEODATABASE_SDE",    "name": "GEODATABASE_SDE_1",    "location": "",    "source": false,    "featuretypes": [      { 

The location is "".

 

For an Oracle Spatial connection:

http://stdcap-koaa-001/fmerest/v3/repositories/BASISDATA/items/KLIC.fmw/datasets/source

 Response:

[  {    "format": "ORACLE_SPATIAL",    "name": "ORACLE_SPATIAL_1",    "location": "BI@PDB1",    "source": true,    "featuretypes": [      { 

 

Dgn and Excel readers/writers also have a filled location string.

Am I missing something?

Thanks,

Annette

icon

Best answer by david_r 14 August 2019, 08:54

View original

2 replies

Userlevel 4

I'm not quite sure that's possible. If you need more information about a specific workspace, you may want to consider downloading the workspace and analyze it further using the FME workspace reader:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/fmw/Feature_Representation.htm

Badge +8

I'm not quite sure that's possible. If you need more information about a specific workspace, you may want to consider downloading the workspace and analyze it further using the FME workspace reader:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/fmw/Feature_Representation.htm

Thanks David. Great tip. Got it working. I was going to resort to reading the workspace in a text file. I didn't know this was an option.

Reply