Skip to main content
  • EN

Integration

Connecting FME to web services. Use of APIs. Mobile Apps.

  • 1,124 Posts
  • 3,950 Replies
1124 Posts
jaygrg111_
Contributor
jaygrg111_Contributor
asked in Integration
What am I missing in uploading a zipped folder to Dropbox

I have a workspace that uploads zipped folder to a Dropbox folder. I have established the Dropbox web connection, token is also retrieved and authenticated. When I run - I get translation is successful with no errors. But I dont see the folder on my Dropbox account. What am I missing ? Any suggestion is highly appreciated. Thank you so much

473
jaygrg111_
Contributor
chris.schulz
Contributor
chris.schulzContributor
asked in Integration
Microsoft Project Online

Hi,  I am attempting to ingest Microsoft Project Online data into our on-prem MMSQL Warehouse. I have found that the only (?) way to get the api is via SharePoint: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData The URL Above lists endpoints for all the sub-components ie: https://<xyz>.sharepoint.com/sites/ProjectWebAppTestSite/_api/ProjectData/[en-US]/Projects I am after recommendations for "simple" one-to-one replication of this data structure in SQL via FME.  The SharpointOnline component allows access to the document as an HTML file which I would have to manually parse and furthermore the site (via FME) only lists 5 Items in a document library wheras the main api endpoint via the web browser lists > 20 endpoints for data objects.The OData connector doesnt seem to work as I believe the feeds are ATOM.The HTML connector fails to authenticate as we use MFA and even if it did, this would most likely be a nightmare to parse.The PowerBI

2271
michielbergman
Participant
virtualcitymatt
Celebrity
virtualcitymattCelebrity
posted in Integration
FME Packages - Using existing database/web connections

How should we use existing database connections inside of an FME Package?Will the python api have functions which will enable the use of these connections? I was working on something where I wanted to connect to a database and I realised that it’s not possible to use the existing database connection - this is probably a good thing but kind of killed my project. Then it got me wondering if this will/should ever be a possibility? seems like exposing that kind of access to third parties poses a pretty big security risk. You could pretty well hide some malicious code which just scrapes all the host, username and password data and post it to some server. I guess direct database access via a package might never be allowed - at least not until there is the same kind of security which Oauth offers for authentication. 

200
virtualcitymatt
Celebrity
mb_fdfa
Participant
mb_fdfaParticipant
asked in Integration
Use Google Earth Engine API

Is it possible to access GEE API from FME (and for example run a script using Sentinel data to extract vector data for edge of recently burnt area)Does anyone have experience in doing this?Thanks.

1035
L
Contributor
sami26beniaouf
Contributor
sami26beniaoufContributor
asked in Integration
Connect to cloud with FME

Hello everyone,Is it possible to connect to a cloud (PIX4Dcloud) where point clouds are stored, so we can download for exemple files automaticly with FME ? Thank you

433
nielsgerrits
VIP
jimmybowden29
Contributor
jimmybowden29Contributor
asked in Integration
ArcGIS Portal Feature Service writer error True curve update not allowed

FME Server 2022.2Build 22765 - win64I have an ArcGIS Portal Feature Service writer set up to update a single attribute. I am getting the following error ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'True curve update not allowed.'I have specified to not update the spatial column so I would expect this error would not occur. It would appear that FME is trying to send a geometry

1891
davekazemi
Contributor
tb09114
Supporter
tb09114Supporter
asked in Integration
Connecting FME Server to MSSQL server

I have the following scenario.We use FME Form to gather public data. The data gathered should be written into a MSSQL database. Since we mainly work with ArcGIS Pro, and other ESRI products our MSSQL  server has an SDE extension on it.As long as I work in Form I can easily use sde connection files to access the databases. However, publishing a workspace utilizing an sde connection will result in errors since we do not have an ArcGIS Pro running on the same machine as our FME Server.Until now I was using the reader and writer ‘ESRI ArcGIS Portal Feature Service’ but this isslow, and requires published feature services in the ArcGIS Enterprise portal.I got our IT to open the firewall for direct access of FME Server to the MSSQL server and installed the latest msoledb drivers after getting the following error:Microsoft SQL Server Spatial Reader: Failed to connect using Microsoft OLE DB Driver for SQL Server. Provider error '(-2147467259) Named Pipes Provider: Could not open a connection t

4225
tb09114
Supporter
C
BANNED
charliekthrnBANNED
asked in Integration
Seeking Help with Data Center Integration

Hey Everyone, I hope this message finds you well. I'm currently working on a project involving data center integration, and I've run into a bit of a snag. I'm using FME to handle spatial data transformations, and I'm encountering challenges in seamlessly integrating data from various sources within our data center. Specifically, I'm dealing with issues related to data format conversions, data quality assurance, and ensuring smooth interoperability between different systems within the data center. I believe some of you may have experience with similar scenarios or could provide valuable insights. Here are a few points I'm struggling with:Data Format Conversions: How do you efficiently handle conversions between different data formats within the context of a data center using FME?Quality Assurance: What are your best practices for ensuring data quality as it moves through various stages of the integration process? Any FME transformers or workflows you recommend?In

170
C
BANNED
hvukasinovic
Contributor
hvukasinovicContributor
asked in Integration
Error with connecting to ArcGIS Portal (Caused by SSLError(SSLError(1, '[SSL: UNSAFE_LEGACY_RENEGOTIATION_DISABLED])))

I have an error connecting to older version of ArcGIS Portal (10.9.1) from latest version of FME Form/Flow (2023.2.1 b23774). Does anyone know how to resolve this issue? 2024-01-23 20:15:03|  0.5| 0.1|ERROR |Python Exception <SSLError>: HTTPSConnectionPool(host='<portalURL>', port=443): Max retries exceeded with url: /portal/sharing/rest/generateToken (Caused by SSLError(SSLError(1, '[SSL: UNSAFE_LEGACY_RENEGOTIATION_DISABLED] unsafe legacy renegotiation disabled (_ssl.c:1006)')))2024-01-23 20:15:03|  0.5| 0.0|ERROR |An error has occurred. Check the logfile above for details

1940
hvukasinovic
Contributor
S
sdlasiter
asked in Integration
We run an FME License Server in AWS on a Linux 2 box. We are required to upgrade to Linux 2023 but the redhat-lsb-core package is not available.

To previously set up our license server we followed the majority of info in this link:https://community.safe.com/s/article/create-fme-license-server The documentation show that the redhat-lsb-core package is required for the license server. The problem is the new Linux 2023 is based on Fedora and CentOS, whereas the previous Linux 2 box was based off the REHL 7, so it's now unavailable. Curious what others who may be required to upgrade their machines to Linux 2023 may have done or are planning on doing?

1030
danminneyatsaf
Safer
T
tdill
asked in Integration
FTPCaller- Error in the SSH Layer

I'm using the FTP Caller Transformer to download a file geodatabase from an sFTP site. I feel like I've tweaked every possible parameter. My data keeps ending up rejected with an "Error in the SSH Layer." Any ideas?

740
J
nielsgerrits
VIP
nielsgerrits
asked in Integration
WebGIS viewers

Sorry, this isn't FME-related, but given the experience here, it would be dumb not to ask. Our team currently employs VertiGIS Studio (formerly Latitude Geographics) Geocortex Essentials as our corporate web GIS viewer. We utilize this to configure project-specific web GIS viewers via a user interface, requiring no coding. It consumes our web services from Portal for ArcGIS, with authorization managed using groups in Portal. Additionally, we can leverage workflows, custom-made user interfaces used in combination with FME Server. The problem is that the product is being discontinued. VertiGIS Studio offers a new web viewer built from scratch, based on ESRI web maps instead of web services. Our issue with web maps is that they are difficult to maintain. Adding layers to viewers during project work is challenging, and there's no option for grouping layers in a folder structure. So we are seeking alternatives. I'm curious to know what others use and what they are enthusiastic a

500
nielsgerrits
VIP
ajbaum77
Contributor
ajbaum77Contributor
asked in Integration
Changes to ArcGIS Portal Feature Service Writer in FME 2022?

I have a workbench I'm updating from 2021.2 to 2022.1. It reads in features and then following the general flow from this article (https://community.safe.com/s/article/how-do-i-write-updates-to-an-existing-arcgis-onlin) does the change detection and then updates the portal service. In 2022.1 I'm running into an error though where when it starts writing the updates I get" ArcGIS Portal Feature Service Writer: Could not find a layer/table matching feature type 'ParcelTest_DBO_DelTest'". I've used the GUI to select the item from the portal, the only difference I can see is the '_' instead of the '.' in the service name. I can't change this though. In 2021.2 the writer has the '.' in the name. I can click on the url of the ArcGIS Portal Feature Service Writer: Requesting metadata for Feature Service at 'https://xxx.xxx.xxx/server/rest/services/ParcelTest_DBO_DelTest/FeatureServer' message and it opens the rest endpoint  

1140
evieatsafe
Safer
panda
Enthusiast
pandaEnthusiast
asked in Integration
Which one do you prefer Bentley Microstation and FME vs AutoCAD Civil3D and FME Intergration?

I don't have experience in Bentley or AutoCAD. We aren't an engineering company, so we won't be using much of the 3D capabilities. I think for most jobs, we use CAD to generate reports, and plats, mostly 2D drawing. So, I would like to ask for some guru advice. 1) What do you like and not like about each software when it comes to integration with FME. 2) If you have to pick one, what would you choose and why? Thank you!

280
panda
Enthusiast
arnaud974
Contributor
arnaud974Contributor
asked in Integration
Download all tiles from a WMS Server

Hi,I wonder if it's possible to download all the tiles from a WMS web server. I would like to cache them as a Geopackage Tiles for exemple or XYZ Tile layers.  Do you know if this is possible ? Thanks,Arnaud

5550
machbrown2
B
bea
asked in Integration
Sharepoint: attachments

Hallo, I am looking for a way to access Sharpoint list attachments in FME.I have tried using FME Reader Microsoft SharePoint List or Transformer SharePoint Online Connector, but the attachments are not retrievable.Are there any plans for FME to add support for attachments?Can anyone suggest another way to download attachments in FME? I would be very grateful for any help with this task.

860
B
S
shoaffsshapes
asked in Integration
Tips for Converting a City to Minecraft - GIS Data Cleanup

I am working on a project to get my home city into Minecraft (Harrisburg, PA - pop. 50,000). I have a QGIS file of about 40 layers consisting of:2D shapefiles (polylines & polygons - to describe materials or edges)2D shapefile of buildings (heights based on a BLDGHEIGHT value in the attribute table)3D DEM (using this for the Ground Level of the Minecraft World) I have seen what could be done in converting GIS to Minecraft from some of the how-to links. I have two concerns, what data cleanup should I be concerned with and would there be anyone out there who might be able to help guide me through the process this next month? This project started in 2013 as an idea to take a 2D image and "loft" a Minecraft world from the pixels (World Painter). This worked well and created a flat creative world. Unfortunately the area was only one neighborhood in the city, approximately an 1/8 of the city. The image allowed some changes in elevation from the Susquehanna River with an ap

1310
A
G
gowripriya2k
asked in Integration
Regarding how to access the sftp location using private key in Fme server configured in Linux Env.

I want to upload a file to sftp location and we have only private key for connecting. I tried using system caller by keeping this command inside that :sftp -i <private_key_path> -b - user@hostname <<< 'put <path_file_to_upload> <path_remotepath_where_to_upload>'and also tried with this command also:sftp -o -i <privatekey_path> user@hostname but none of the commands worked in fme server, it is showing as failed to execute the command, Am I giving the correct commands or could anyone help me out on how to connect to sftp using private key in fme server configured on linux env.

1973
debbiatsafe
Safer
M
mapsrus
asked in Integration
Can FME be used to produce heat maps?

Can FME be used to produce heat maps?  Kind of like this:  http://www.openheatmap.com/  I have about 20 million points and I would like to show where the hotspots are.

1940
maaw306
Participant
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Integration
Hey, anyone at Safe goning to build a GPT with FME knowledge?

Referring to this: https://openai.com/blog/introducing-gpts I'd love to see a GPT fed with FME's documentation - also the Python API It's be great to have FME's built in AI tools use something like that to give more FME specific answers? Just an idea 

90
virtualcitymatt
Celebrity
R
robdessington
asked in Integration
"Failed to retrieve feature types." - ArcGIS Portal Feature Service Reader

Attempting to read a layer via a Feature Service on Portal. As I am the owner I have the relevant permissions to access the layer, and it also has relevant editing permissions. This is confirmed by being able to edit the layer in Portal itself. However, when attempting to read in the layer I am met with the error in the question title. I can successfully connect to our portal, and even the Feature Service using the reader - it just fails when attempting to select the layer. See below:I should add that the log does not provide any useful information. Appreciate that this could be rooted in Portal configuration but any guidance much appreciated!

890
ctredinnick
Supporter
E
emilef14
asked in Integration
Can I import a custom python package from an azure repo into FME?

We have a custom python package project sitting in an azure repo, with build pipelines. This python package can be built on multiple python versions 3.8, 3.9, 3.10 with the help of the Hatch third party package. One of the pipelines produces an .whl artifact for the project, can this be used to install the python package locally on any machine, and simply point FME to this package? I don't really know all the intricacies associated with this approach, if it is possible can you please take me through the steps to achieve this or point me in the direction of a detailed article, any help will be appreciated

222
E
R
ramanuja
asked in Integration
How to access ADO work-items from FME ? I explored different ways like providing personal Access Token, Username password but it is giving Status code 203 Non-Authoritative Information

How to access ADO work-items from FME ? I explored different ways like providing personal Access Token, Username password but it is giving Status code 203 Non-Authoritative Information

230
hkingsbury
Celebrity
E
emurdoch0
asked in Integration
How to authenticate Esri ArcGIS Online (AGOL) Map Service via SSO

Hi, I'm trying to create a connection with my enterprise ESRI account, but only have the option to enter a username and password, when I can only connect to this account via SSO. Any idea how to work around this? I have set up a web connection to my ESRI account but it doesn't automatically connect to the map service through this.

520
nielsgerrits
VIP
mackjohnson
Contributor
mackjohnsonContributor
asked in Integration
Web Traffic security between FME Flow and Snowflake

We are looking to set up an integration between Snowflake and ArcGIS Online and need some assistance with network security.  We've found that ArcGIS Online encrypts all traffic to and from through TLS 1.2 or later with AES256. We also found that Snowflake operates in the same manner.  This would mean all web traffic to and from both data sources and the FME Flow server would be secure through the above protocols, correct?

383
mackjohnson
Contributor

Badge Winners

Show all badges

Community Stats

31,073
Posts
117,798
Replies
38,834
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.