FME Form

I need to download one or more PDF documents from Sharepoint as part of an export process. These PDF’s have random titles and filenames, in the Sharepoint library an extra column was added containing a unique ID. It’s this ID I have to use in order to download the correct PDF.Problem is that I can get this ID from Sharepoint using the Sharepoint Online List Reader, but that cannot give me the download URL. Conversely I can get the download url from the SharepontOnlineConnector transformer, but that one does not allow me to get the added custom ID.So in order to get all the info I need,  have to use the reader AND the connector and join the results from both together, which is rather ugly.Am I missing something? Is there a way either of these can be configured where I get all the necessary info in one go? Or is this as designed? If the last, I’ll file an Idea I suppose...

Quick question.Are there alternatives to using AttributeManager to manually sort attributes by name?Sort of an AttributeSorterByName or AttributeSortedReexposer transformers ?Cheers.

Hi all.I’m experimenting with calling WFS services with custom filtering expressions, including spatial filtering.According to the filtering documentation, spatial filtering is possible with GML, but it doesn’t seem to work in FME ?The geometry column is present but has no value in the output from FeatureReader, and FeatureReader has its own spatial filtering parameter separate from the “normal” filtering parameter (using <Filter/>)Am I correct in assuming, that FME effectively prohibits any spatial filtering via the “normal” filtering parameter, and requires you to always use the special FeatureReader spatial filtering parameter ?And maybe this is neccesitated because FeatureReader removes the WFS geometry column values ?Thanks for any insights.

Dear community, I have implemented a workflow with FME and ArcGIS Enterprise, in which an automation is triggered in FME via a referenced feature service with a webhook. Based on the entries in the ArcGIS Field Maps App, an e-mail is then to be sent via FME.This is set up accordingly according to the following documentation: https://support.safe.com/hc/en-us/articles/25407414850061-Integrating-ArcGIS-Enterprise-Feature-Service-Webhooks-With-FME The connection from the application in ArcGIS Enterprise to FME is also set up accordingly: https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0 The problem that arose is that the OAuth refresh token created in ArcGIS Enterprise has a default lifetime of 2 weeks and I therefore have to authorize myself every 2 weeks (see https://enterprise.arcgis.com/de/portal/latest/administer/windows/specify-the-default-token-expiration-time.htm).Based on this community entry: https://comm

Hi.This may be a simple or a complex question, I’m not sure which.I’m attempting to use a dynamic expression, that I construct dynamically from values read from a file or table, and evaluate it on all relevant feature read from a database or file. Including AND/OR etc.How can this be achieved in Workbench ?I’ve tried to utilize ExpressionEvaluator with the expression @Value(@Value(expr)), but it doesn’t return any value in the “_result” variable.What am I doing wrong, and is it even feasable ?Are there better ways to achieve this ?Using 2025.2.4Cheers

Hi all.I just created a new custom transformer, and need to apply it multiple times (10-20 times).It basically just has a name and three parameters, all of which can be deduced from a database query.So I thought it to be a good idea to create and paste the definitions from a query result (using some sql magic). Instead of copy/pasting the many transformers as I would normally, editing each by hand.So I experimented at bit first.I can copy a transformer from FME Form, and paste it right back. I can also paste the definition into a text editor, as the copied content is just text (FME file syntax).But when I just copy the complete transformer (without changes) back from the text editor (Ctrl-A,Ctrl-C), FME Form will not paste it into the workspace.I used Ditto clipboard to look for differencies, and I can barely find any. The two attached images shows the properties for the original and the text editor copy.original from FME Formtext editor copyThe only difference I can find are the sligh

Hi, I followed this guide (How to Connect to Microsoft Exchange Online using OAuth 2.0 (Microsoft Modern Authentication)) for setting up MS Exchange with FME Form 2026.1.2.0. Once I worked out things are a little different with a Personal Database for Connection Storage, I ran into an issue where I couldn’t set the Redirect URI unless I used the old Embedded Browser Redirect method.As this method is deprecated what’s the option going forward, as the other two options don’t let a user edit the Redirect URI:Thanks

I have a workspace where FeatureMerger_2 and 1/3 connection is disabled, but when I trigger a Partial Run from the upstream reader BODENBEDECKUNG_A, I get the "Caches required to run translation are missing or stale" prompt, listing all the transformers that feed into that disabled FeatureMerger (See attached screenshot)Since the FeatureMerger itself won't execute, I'd expect its exclusive upstream feeders to be treated as dead and excluded from the run, but apparently they are still requiredIf I instead disable each incoming connection to the FeatureMerger, the feeders correctly drop out of the run and I don't get the prompt, even when Feature Merger is enabled.Can someone explain the logic here? Why does disabling a transformer and the relevant connections (the one coming from the reader where the Translation is started) not back-propagate to exclude its upstream feeders, while disabling the connections does?

When I try to connect the .sde file on FME, I got the this Error. 

I've got a few challenges concerning styling of an excelsheet. It's not just an ordinary sheet with columns and rows, but it's a reporting template. The report contains several attributes in different fields and several images. The issues/challenges I'm currently facing:I would like images to fit itself into a named range or predefined rows and columns. See screenshot below. I created a predefined named range ‘overzichtskaart’ which covers cells $C$4:$E$16. But as far as I can see there is no option to let FME/Excel know that the image should stay in those cells. I created a workaround now which tells the image that it should align in xlsx_row_id 4 and xlsx_col_id2 with a height and with of 255 pixels. But this goes wrong as soon as the alignment of the attributes changes (for example multirow text in column B). Does anyone have a smart work-around to fit the image exactly in the desired cells? Named ranges are useful to make sure that the attribute-data ends up in the right cell, but

 Hello,I would like to remove attributes (or columns?) from my data stream that have no value (missing or null)In below example that means “eindegrarantieperiode” and “integraalproject” need to be removed. Note: can we do this dynamically? I don't want to manually go through 50+ attributes to check if they contain a value or not.(FME 2025.0) 

In >2026 to connect to AGOL or Portal enterprise from FME, we utilise the “unified” Esri ArcGIS Enterprise OAuth (Template)(safe.esri-agol) web service   ARCGISFEATURESERVICESWorking with Esri ArcGIS Feature Services in FME – FME Support CenterThe article perhaps fails to mention how to handle the web service Loopback Interface Redirect or Proxy Redirect Strategy, as the Embedded Browser is deprecated in FME Form 2025.2The arcgis registered application needs to have http://localhost as redirect URIWhat about FME Flow redirect URI?My suggestion is in Connections & Parameters - FME Flow for any given safe.esri.agol newest Esri web service in Flow >26It needs a default Redirect URI of “ self “? 

After the June 2026 ArcGIS Online update last week, the Esri ArcGIS Connector stopped working when attempting to download .csv admin reports. Prior to last week’s update, the connector would download these .csv files without issue. As of last Friday (6/26), FME returns the following:fme_rejection_message: 400 Client Error: Bad Request fme_rejection_code: INVALID_FILEwhen attempting to download .csv file. These errors persisted over the weekend and today. It fails both in FME Form and FME Flow. Versions I am using:FME Form: 2025.1.2.0 (Build 25630) FME Flow: 2025.1.2.0 (Build 25630) Esri ArcGIS Connector: 3.25.1Note: This exact error is returned for multiple types of .csv files generated within AGOL. I have dug into Chrome Developer’s tools to compare and confirm URLs and Payload being sent to the API and everything looks the same on both ends (Chrome and FME).Something might have changed with AGOL API’ backend. Is anyone else seeing these same issue? If so, how did you resolve it? Or,

Hi all,I am trying to write a dynamic Excel formula (=SUBTOTAL(103, A2)) to an Excel sheet using FME Form, so that it evaluates automatically when a user opens the spreadsheet. However, FME keeps writing the formula as a literal text string (showing =SUBTOTAL(103, A2) in the cell) instead of calculating the actual formula.Here is what I have configured so far based on the documentation: AttributeManager: Created an attribute named ZICHTBAAR.formula Value set to: =SUBTOTAL(103; A2) (or with a comma depending on locale) I also exposed the base attribute ZICHTBAAR without the extension. Excel Writer Feature Type (User Attributes): The column ZICHTBAAR is present. I tried setting the Data Type to both string and auto. The issue: When running the workspace and opening the output file in Excel, the cells still show the raw formula text. It only evaluates to 1 or 0 if I manually double-click the cell and press Enter, or force a hard recalculation.What am I missing to

hi,I'm trying to load data from a WFS service into a database.The WFS service contains 25 feature types (tables) with a total of more than 153,000 features.Here is my FME workspace:CreatorHttpCaller (retrieves the list of layers)PythonCaller (extracts the 25 FeatureType layer names)HttpCaller (GetFeature request using typeNames=<layer>)PythonCaller (retrieves the numberMatched and numberReturned values for each layer)Tester (numberMatched == numberReturned)PythonCaller (retrieves the features, transforms the geometry, etc.)CounterAttributeManager (adds a unique ID using the counter)SchemaScanner (collects the 25 schemas with their attributes, along with the 153,000 features)FeatureWriterThe issue is that the FeatureWriter doesn't correctly associate each schema with its corresponding features.If I insert a Sorter transformer before the FeatureWriter, the workspace runs successfully, but all attributes end up being written to every table instead of only the attributes that belong

There was an update to ArcGIS Online last week 06/2026 that is causing an issue with the number of records you can read using the AGOL reader. It is limited to 400k records. Since the hosted layer that I am reading has way more than 400k it has broken my workbench. Has anyone ran across this yet and is there a workaround I can use since this workflow is essential for updating an enterprise application.

I am looking at this Article for setting up Azure OAuth Connection for Data Bricks, the article is for Reader, but I assume the same set up will work for the Writer.   We have an Azure app already set up for the FME SharePoint Reader and Connector, can the same Azure app work for both SharePoint and Data Bricks ? are there any best practices about using the same Azure app for both or making separate Azure Apps for each ?   Any suggestions or cautions, things to watch out for, etc,  appreciated  https://support.safe.com/hc/en-us/articles/27147444106381-Setting-up-a-Databricks-Reader-Azure-OAuth-Connection   

I have an issue with a working workspace that has run for a couple years now. Recently, since 28/5 I have issues with writing integer values.What I’m trying to do:Insert point features into an existing ArcGIS Online hosted feature layer using the Esri ArcGIS Feature Service writer. Integer attributes (e.g. reportYear, equipmentNr) should be written with their actual values, e.g. 2026 / 2027.What happens:Every integer field is written as 1 in the target layer, regardless of the source value. In the Data Preview right before the writer the values are correct (reportYear = 2026 / 2027). After the insert, the integer fields all show 1. I reduced this to a minimal workspace (reader -> AttributeKeeper keeping only the integer attributes -> writer) and it still happens.Environment:- FME Form 2025.1.2.0 (Build 25630)- Esri ArcGIS Connector package 3.25.1- WindowsWhat I have verified / tried (none fixed it):1. Values are correct integers in Data Preview, immediately before the writer.2. C

I have encountered an issue where using a Snowflake writer will either cause errors or corrupt data if the text field contains emoji characters. This is occurring with FME Form 2025.2.3.0 on Windows 11. If I am writing to a VARCHAR column in Snowflake, the emoji characters will be corrupted but the field will write. If I am writing JSON to a VARIANT column, the workspace will fail with an error. In the past I have just let this issue go because I have been writing to VARCHAR fields. Now that I’m writing JSON to a VARIANT, I need to find a better solution. Although I believe FME 2025 and Snowflake are both using UTF-8, it looks like it is getting converted to something else somewhere along the line. The easiest way I have to test this is to create a Snowflake table:create table mm_temp_utf8_test (text_col varchar, json_col variant);Then I can use a SQLExecutor.If the SQLExecutor just populates the VARCHAR column, it will succeed but the data will be corrupted:insert into mm_temp_utf8_te

I just found that in the geodatase_sde writer, you can create domains for the field you’re creating. This is very exciting news! And the domain is indeed created in the SDE database. However, when I view the featureclass in arcpro, the domain for that field is not there. I still have to associate that domain to that field. Has anyone tried this? Is there a parameter i’m not seeing? I’ve checked all the parameters around the field, the feature type, the writer and didn’t see anything that could be it. The documentation didnt have any info except on how to create the domain. bug or feature? 

I’m trying to connect to Salesforce in form with 2026.2, but every time I do, FME never finishs authenicating. My log in on Salesforce goes fine, but it still says waiting authenication in FME. Do I need to change a setting?

Hello,We are currently upgrading an FME-based application for one of our customers from FME 2020 to FME 2024, and we have encountered an issue that appears to be related to coordinate system handling.The application uses FME to convert a set of DGNV8 drawings into an MS SQL Server database. For some drawings, we observe a positional shift of approximately 10 centimeters (a few decimeters at most) after processing.In the DGNV8 Reader, the Coordinate System parameter in the Navigator window is set to "".When inspecting the source datasets with FME Data Inspector in FME 2020, all drawings are reported as having an Unknown Coordinate System, regardless of which file is opened.However, in FME 2024, we see different behavior:For some drawings, Data Inspector reports the coordinate system as EPSG:28992. For other drawings, it reports NationalRD-NL.The drawings belonging to the latter group appear to be shifted relative to the other drawings.My questions are:Is this behavior related to differe

Just recognized, after migration of a workspace from 2024.2 to 2025.0 a BulkAttributeRenamer shows strange results: The transformer is set to change attribute names to lowercase (mode rename) for a selected set of attributes. This works as expected. However the remaining attributes (not selected for any change) got almost completely removed. ‘Almost completely’ means from the >5000 records only 4 have the attribute after the transformer while all other records show the attributes as <missing>.@safe - although it’s easy to mitigate it might be worth to dig into it.note: in mode ‘keep original attributes’ results are as expected.Klaus 

Has anyone else noticed when creating a list using the AttributeExploder it truncates the last two characters of the list name, resulting in complications when using a ListExploder downstream because the list doesn’t exist.Using the default settings:Default List Settings in the AttributeExploder Transfomer The resulting list:List Name Is Truncated In Feature Information This broke a workspace that was previously working. It was a niggly one to catch as the only thing that had changed was the FME version.As a workaround, we created a user parameter which had the default value “_attr_li{}” and used that in the ListExploder which worked. FME Form version:FME(R) 2024.1.1.0 (20240729 - Build 24619 - WIN64)

I was using Service account Key File as a credential source for google cloud storage connector but it looks like its been removed as an option. anyone else seeing this?