Integration

Hi, I am using FME workbench 2024.1 to read an SDE database, every ting looks good, but tables can not be loaded. SDE database works in ArcGIS Pro, and the testing data connection in FME are also good. Anyone has experienced the same?

We just started integrating data to GCP BigQuery by adding a system environment variable called ‘GOOGLE_APPLICATION_CREDENTIALS’ and pointing that to the service account key file. I am anticipating a need to integrate with a different BigQuery and would like to know how to run parallel integrations to two different GCP accounts. Any thoughts? Thanks.

Hello everyone, We are encountering an issue when using the SharePointOnlineConnector. My colleague, who is a member of a SharePoint site, was able to retrieve all files from the site using the HTTPCaller. However, when attempting to retrieve the same files using the SharePointOnlineConnector, not all files are returned. We are unsure why the SharePointOnlineConnector does not return the complete list of files from the site. For further clarification pictures are added: My colleague can access a specific list in Sharepoint itself (Codes) In the SharePointOnlineConnector, after connecting to the same Site, the list Codes is not available to him. Codes is a List and not a Document. Maybe that might be the reason why Codes is not available? ---------------------------------------------------------------------------------------------------------------------------- On the Azure App Registration side, the settings are configured as follows: Permission Type: Delegated Permission app registrat

We are migrating to FME 2025.1 and I have a question about arcpy and the Emailer. I have a workbench with a Creator and a PythonCaller. In the PythonCaller I added import arcpy. Python Compatibility is set to Esri ArcGIS Python 3.11. This works. Now I want to add the Emailer transformer and I get the following screen: If I Choose Cancel, I get no Emailer. If I Choose Change Python Compatibility, I can add the Emailer. But now I the PythonCaller fails. To solve that, I need to Change the Python Compatibility back to Esri ArcGIS Python 3.11. But if I do this, I get the following screen: How can I configure my workbench to have both a working PythonCaller using arcpy and the Emailer transformer? I need this on desktop (combined with ArcGIS Pro 3.5) and on server (combined with ArcGIS Enterprise 11.5). The following transformers are problematic as well: SharePointOnlineConnector HTMLReportGenerator AutodeskDocsConnector

Hello everyone! So I’ve had a workflow run fine for the past 2+ years. It involves using HTTPCaller to send a GET request to our OpenText ContentServer repository and download a csv document as an attribute for further processing. It appears that at some point in late June, the service credentials we’d been using all along are no longer working in FME or something because we’ve been consistently getting a 401 error in the rejected features port of the HTTPCaller. We’re seeing this behaviour in both FME 2022.2 and 2024.2. The thing is, the same credentials will work fine when the URL request is done manually through the browser. The setup has originally been NTLM, with the service username and password passed from User Defined Parameters. When I check ContentServer’s authorization settings through the browser’s Developer Tools it still shows up as NTLM too, so that hasn’t changed. I’m hoping for any ideas or leads that I can look into. Is it possible that something was done on the Conte

We are migrating to FME 2025.1 and I have a question about arcpy. I set the Python Compatibility to Esri ArcGIS Python 3.11. I then add a PythonCaller. Now workbench asks me to change the Python Compatibility to Python 3.13+? If I choose Cancel, I won’t get a PythonCaller. If I choose Change Python Compatibility, and I add “import arcpy” the workbench fails. What am I supposed to do to let FME 2025.1 run arcpy? Also for FME server.

I would like to use Flow to send an email once a record is being added to a survey123-form in Arcgis Online. This email should contain the record fields and attachment (image file, 1 for every record). When using a webhook + workspace in Flow I am able to sent an email with the record fields using the emailer transformation. However, I am not sure how to send the attachment (without placing it on the server first). I am not sure what I should fill out in the 'source file' field in the Emailer transformer. I tried: inserting the attachment url first converting (with RasterExtractor) and then using the rasterblob. Both send the items to rejected. What should I fill out here? Or is this not possible without first downloading the image?

Hey! I was wondering what the best practices are when it comes to updating a sde table that has archiving enabled. I have a few tables in a sde database that I need to update regularly. These tables have archiving enbaled and the tables have between 100,000-900,000 records. I have noticed that when I want use “Truncate Existing” in my sde writer that it takes a long time (I’ve never actually had the patience to let it run to completion… I usually cancelled it after a few hours) If I use the “SQL To Run Before Write” to truncate the table before I write to it, all the “archived” data gets lost. If I use the arcpy function “Truncate Table” in a Python Caller right before I write the data to the table it works really well, it doesn’t take too much time and the archiving function is working as well. I guess one other option would be to detect all the changes and only update those rows but for different reasons this makes the workflow a bit more complicated. But maybe something worth lookin

I’m currently dynamically reading web feature service layers by using a feature reader and trying to write them up to AGOL. I have no issues dynamically writing to a File GDB, but if I attempt to write to AGOL, I only get a Python KeyError, which isn’t telling me anything. Message Type: fme::internal::_v0::py::ExceptionPython Exception <KeyError>: 'Cadastre_Address_LGATE002'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for details This only occurs when I want to write dynamically to AGOL, if I just write the exposed attributes it functions. Is there any way around this? I’m aiming to use one workspace to read in the features based on parameters, and write it out using parameters, as a way of creating and updating feature services. I should note that it seems to be half creating the feature service itself, but when it comes to write any features to the newly made feature service, the error appears. Thanks

Hi FME enthusiast, I am trying to read a large size of shape file using fme form (formerly desktop) where the file size 2GB. when I select the file in the esri shape file reader and try to add in workspace I am get the error like image attached below. The server have enough space to perform but I am receive error attached. Did anyone have face this issue earlier?. If anyone have any suggestions, all would welcome. Thanks in advance.! Notes: These shape files are exported from Smallworld using FME only. I am using FME Desktop 2020.1.1.1 32 bit version.

Hi All, I'm still somewhat new to FME and am hoping someone can advise me. Through another workbench I have been able to gather a a list of service URLs from an AGOL. I would now like to automate the process of creating a new item in ArcGIS Portal via the New Item > URL workflow. I have looked through the Esri ArcGIS Portal Feature Service Reader/Writer and a few other transformers but none seem to accommodate for creating a referenced item via URL. Google is leading me nowhere either. Any advice or pointers? Thanks very much for your time!

Hello All, We use FME server 2021.2 as an integration platform and it is not configured for HTTPS. Organization internal systems call our FME workbenches via webhook. ArcGIS Portal Feature Service Reader fetches data from ArcGIS portal feature service. It executes successfully most of the time but fails very intermittently causing data discrepancy between different systems. The failure message is: ArcGIS Portal Feature Service Reader: SSL certificate verification failed for host 'xxxx.xxx.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: HTTPSConnectionPool(host='vgggg', port=443): Max retries exceeded with url: /portal/sharing/rest/generateToken (Caused by SSLError(SSLError("bad handshake: Error([('SSL routines', 'tls_process_server_certificate', 'certificate verify failed')])")))2025-03-05 11:15:58| 0.1| 0.0|INFORM|ArcGIS Portal Feature Service Reader: Getting item with ID 'c505638a9b14460f8267d0a7b562ee48'2025-03-05 11:15:58| 0.1| 0.0|WA

Hello all, At a client I often fail to connect to their ESRI Portal, due to failing to verify SSL (see loggin below) on both FME Server and desktop. Proxy settings in FME don't change the behaviour (always uses proxy). The Chrome browser thinks the certificate is o.k. I can't disable ssl-verification in the Portal Reader, as suggested in the log, like it is possible to do in the HTTPCaller.. (see my idea for that). Inspired by this reported problem I exported the certificate from Chrome, and imported it in $FME_HOME\jre\lib\security\cacerts on desktop.. (analogue to these instructions for server, section .pfx certificate, as the problematic server has a .pfx certificate). This did not resolve the problem... Does anyone have any suggestions??? Kind regards, Martin ArcGIS Portal Feature Service Reader: Using proxy http://proxy.####.intern:8080/ ArcGIS Portal Feature Service Reader: Using authentication type 'NTLM'ArcGIS Portal Feature Service Reader: Logging into 'https://geoportaal.####

Im trying to work with the Cityworks API to create Work Orders using FME desktop. I used the http caller to create the Work order and populate the necessary fields. However, my next challenge is to upload an attachment to the Work Order that comes from the attachment in the AGOL feature Layer created from Survey123. To do that I have used another HTTP caller set to POST with the URL .../services/Ams/Attachments/AddWorkOrderAttachment? I know I have the Query string correct but I'm doing something wrong in the Multipart Upload section. Also, Do I need to use a token if I'm using a web connection for Authentication?

Hello, I've got a really challenging question received from a customer ! The domain is Heritage buildings protection. An architect/historian evaluates the value of buildings and gives them a mark. He then presents his proposal in a PowerPoint : Identification info Description Mark Label etc. Pictures The proposal is reviewed in several sessions, with different people. The mark may be upgraded or downgraded, the label changed, etc. Once validated, the data is to be captured in an SDE geodatabase. Presently, this is done in two different ways : Manually Manually copying the data to Excel and it is imported in GDB with FME But in both cases, there is a non profit-adding step, which is to manually copy the data. Does anyone out there have an idea how to skip this step ? Could the PowerPoint presentation be structured in such a way (with keywords for instance) that could make the content recognizable and importable directly ? I have thought of different ways but I'd rather keep it open for

I was wondering if I can hide the input field that comes with the Geometry Parameter when creating a workspace app in FME Flow. My users are all over the place, some of them understand that they have to set a point on the map and are confused thereafter when a whole GeoJSON syntax shows up instead of coordinates they expect, others think they should write a street address in the input field (mistaking the input field for a geolocator), etc… I can leave a message for them but hey, how many will read it...

How to trace downstream in the network with multiple sources and accumulate the value from the intersected nodes of each trace? To Illustrate please see below. Black circles are the starting points. Appreciate your help.

I am trying to figure out how to parameterise the layer name for a Portal Feature Service reader. In the screenshot below you can see the highlighted Layer Name field. However it does not seem to have the ability to set it as a user parameter. You can see it is possible to set other layer variables as parameters, eg Input Geometry Type, etc. Just wondering how I might do the same for the layer name?

Hi, Anyone used the i-twin model API to download data? Any advice?

From the attached image, I am running a workflow for QAQAC for 2nd Level Check of Electricity Data, and I discovered that some of the transformers is showing under Incomplete Transformers, and also I am having an error showing (ERROR_2.1B:Wrong QA/QC WorkflowKindly run data with the most recent workflow) based on the way the FME Administrator developed the workflow. My question is this, if a workflow is developed with older version of FME like 2 years Gap, does result to some Transformers been listed under Incomplete Transformers, and how can I resolve such Transformers.

I’m working on a project where I need to replicate the table structure from an Oracle to SQL Server but without transferring any data. Essentially, I want to: Read tables from Oracle, recreate the same tables in SQL Server and write only the schema (field names, data types), not the records Is there a best practice to force FME to write only the schema? Are there limitations I should be aware of (e.g. no support for constraints, indexes)?

I have a list with values in an attribute which contain diacritics. I would like the user to be able to choose multiple values and then upload it to Flow for self service data download. However, when I open an oracle spatial reader in Forms and use the where clause to add them it doesn't work. What would be the best way to solve this? The where clause of the reader is now as follows: "active" in '$(choose_status)' and "municipality" in '$(choose_municipality)' both attributes are strings and published parameters the list includes only values from the oracle table ‘allow multiple selection’ is on choice list delimiter is ',’ default value is a municipality with diacritics. The first (choose_status) works. The second (choose_municipality) contains diacritics and does only work for values without diacritics. I also tried a Tester (municipality in $(choose_municipality)) but it also only works for values of municipalities without diacritics.

I’ve come across an issue a couple times where the Oracle writer appears to go stale after a few months of working fine. Has anyone else come across this issue and do you have a better fix than mine? Problem: I run an FME workbench that writes data to Oracle, the workbench completes successfully and the log file tells me fme_features were written. When I go look in Oracle to confirm the deltas, the records were not changed. Current fix: If I replace the Oracle Writer and re-run the workbench then the records in Oracle do get changed. Any help would be appreciated

Hi everyone, please is there any way how to read the full path of the file from GoogleDrive (e.g. Shared with me/Division A/Documents/PDF/data_view.pdf)? I can see that GoogleDriveConnector can load just _relative_path (e.g. Documents/PDF/data_view.pdf). Thank you so much! Lubo

Hello everyone, For my use case, I would like to retrieve information from a SharePoint site of which I am an owner. Specifically, I’m trying to find out who the members of the site are and their mail-adresses. Do any of you have an idea of how I could approach this? I looked into the SharePointOnlineConnector, but it seems I can't retrieve site metadata using it. I might be missing something.