Automation

I have a Web Connection configured that I use in my HTTPCallers as Authentication. This works fine on FME Desktop and also works for some time after uploading to FME Server. But after an hour or so (the expiry time of the token) all workflows on FME Server fail. So my guess is that the Web Connection does not refresh the TOKEN. Do you have any recommendations?My Web Service Settings:Acces Token Request: Request URL: configured Request Data: configured Access Token Response: Token Object Key: serviceResponse.access_token Expiry Time Object Key: serviceResponse.expires_in Expiry Time Format: Duration (Seconds) API Call Parameters: Placement: Header Header Format: Authorization: Bearer [TOKEN] This is the error log I get:`_error' has value `HTTP/1.1 401 Unauthorized' `_http_status_code' has value `401' `_response

Hello everyone, I need to create a loop in FME 2021, this loop would allow me to be able to browse several tables of several schemas of my database to retrieve a specific column "last_update" and then sort this column to retrieve the "last update date". So I would like to retrieve the "last update date" of all my tables but I don't know how to create a loop in FME 2021! Thank you for your help!

Hey everyone,ich have a nice use case in our city: we want to offer a service where families can look which school is the nearest. My Idea was an app Server to create with only one field in order to type one Address. The System should calculate all the routes to the schools in the city (these addresses are known) and visualize them as a list or/and in a map as a result of the server app. Do you think this is possible? I need first of all a FME workbench with an address and a file with the school addresses and calculate the routes and I have problems to get it.  If this task is done, do you think is it possible to show as output the list with the distances and the routes in a map? many thanks in advance!

On FME Flow, can I use the same SharePoint Online Connector Webservice for the SharePoint Online Connector and the SharePoint List Reader/Writer?

I’m trying to learn how to use loops, so I’m creating a basic dissolve loop. However, no matter how many iterations I set it to run for. It seems to go on infinitely. Also, although the loop is set to ‘loop’ back to the ‘Looped’ input, it seems to keep looping back to the ‘input’ transformer?I’ve attached both the workbench and the shapefile I have been using for this test, any help would be much appreciated.ThanksB

Hi folks!Trying to build am FME Flow/Server Automation where if a backend API table is updated by a user that it triggers running an FME workspace that I’ve already uploaded to FME Server.What would be the appropriate trigger to use to kick off the process? Would I have to create a webhook on the API table URL somehow to trigger based on FeaturesCreated and FeaturesUpdated?So whenever the attributes in the API table on the backend are updated, I’d want FME Flow/Server to kick off firing off that FME workspace.Thank you!

Hello :) I get this message on FME Server 2022 and I do not know what is wrong.

Hello, I am trying to use the sample AR demos available in FME flow 2023.1 but those AR demos are not working for me. Getting blank screen after I run the tool. I tried in Android and iOS phones as well. Installed FME AR in android and iOS.  Can anyone pls refer me to the configuration steps for running the AR demos. Thanks in advance.  Thanks,Mudit

Using FME Server FME Server 2021.1 (Build 21607 - win64) I have created a Directory Watch automation to send an email if any new file added into the Directory Which is working as expected but can some one please let me know how I can grab information like File name and SIZE and time and send it to by the email. 

A user attempted to run an FME Flow App and encountered an error message saying, "You are Forbidden". The Flow App needs credentials to access, which were provided. The user was able to successfully upload the required file. What can be the cause of this issue and how can I resolve it.

Hello all,Today I fell into a rabbit hole with the HTTP request action in Automations (2024.1).As the Action lacks the parameters key-value interfacing of a fully fledged HTTPCaller, I needed to build-up the parameter-part of the URL in the text-editor.There, some URL encoding happens. Spaces are substituted by %20 at least. But I was unable to parse a GeoJSON as the [ ] were not encoded. When I manually url-encoded the parameter values, the encoding (%) was encoded(%25) , so I still did not get a valid GeoJSON from a manual-trigger-Geometry parameter to a parameter in a workspace REST-webhook.I remember around 2016, the default server.xml in a FME Server installation did allow for non-encoded brackets through an exception in the <connector>. That has long gone in the standard install. Using Kubernetes, even if I wanted to, I would not know how to put that back.So:Has anyone figured-out the encoding which does occur (which an

Pretty much just as the error says:“There was an error submitting the job. COM.safe.fmeserver.api.FMEServerException: Job submission failed. Could not acquire valid job queue.”This displays immediately after pressing run in the workspace runner on FME Server 2021.2.5.I’m not sure where to start investigating and thought maybe someone could point me in the general direction.   

Hi! I have an automation with an email trigger, and I want to use the emails subject in the FME Form workspace, how do I do that?  

(We use FME Flow 2024.0.2.1)I have an automation with about 20 actions. In the first action, a folder is read. The files it contains are the input for the other actions (written out with a automation writer, input parameter for the actions: route.xy)However, it should also be possible to start the automation with the manual trigger and specify a file as a parameter, which is then used as input in the subsequent actions.But this means that the input parameter for the other actions is not route.xy, but manual.xy.Is there a way to set the input parameter for the individual actions so that the correct path is used in each case (route.xy or manual.xy)? Or do I have to duplicate all actions and set route.xy for one half and manual.xy for the other (after the manual trigger)?Thanks, Vera

The title is self explanatory. I need to upload or create dozens of database connections and I found cumbersome to upload only once of them at a time.How can I do that? May I share a folder with them? 

Pretty much as the question asks. If I stop and start an FME Flow Instance or reboot an FME Instance, will the automations know when next to run based on before the instance restarted, or will it start the repeat from the start of the selected interval?Thank you for your help!Nick T

Hi, I’m new to FME, looking to setup a python caller to manipulate some feature services on our Enterprise portal.Is it possible to call feature services from within a python caller inside a workspace hosted by FME Flow?The script below works fine in FME Workbench and prints True, the FME Flow prints false. import fmeimport fmeobjectsimport arcpyfrom arcgis.gis import GISfrom arcgis.features import FeatureLayerdef ProcessWebhook(feature):        # URL to AGOL or Portal        url_gis = "https://<servername>/portal" # URL to AGOL or Portal        user = "xxxx" # AGOL or Portal username        pwd = "xxxx" # user password        gis = GIS(url_gis, user, pwd)        id = feature.getAttribute('webhook_feat_id')        whereclause = 'field_3 = ' + "'" + str(id) + "'"        in_feat_url = r"https://<servername>/hostedserver/rest/services/Hosted/service_3c55880fb4112b08f

Is there a way to set the font of the text in the Logger transformer as it is displayed in “View Details”?The Logger transformer has an option to set a font. I set my font to Consolas Regular 12Then I ran the workbench on FME Server (FME Flow)The I clicked on “View Details”I could see the text that was created by the Logger, but it was not in the font that I had chosen 

Hi all, We upgraded from FME Server 2021.1.5 to 2022.1.1 a little while ago and since then our automations no longer seem to be triggering jobs. Each of the automation logs shows a scheduled trigger event at the correct time, but no jobs are getting queued. Manually triggering an automation also does nothing, apart from showing a green 'Automation triggered' message in the web interface and adding a successful event to the automation log. Everything else about the server seems fine. Schedules run at the time they're meant to and queue jobs up properly, and I'm able to run all of the workspaces that should be automated with no issues at all. All of the server logs I can find show no obvious errors and fmeserver.log shows no hint of any of the jobs being run due to automations. I've tried uploading a completely fresh workspace to the server and setting up a new automation. The logs show the automation being assembled

Hi all. I am working on an automation triggered by Survey123 submissions based on webhooks. The initial part is working ok, but I am running into some strange behaviour:As it is now I have an automation with a webhook trigger that starts an action to run a workspace. This workspace parses the data from the webhook, sorts the input into various outputs depending on choices made in Survey123 and sent data to separate FME Flow Automations.Each of the outputs contain two attributes; one with a code for how the registration will be handled further downstream and one with the globalid for the Survey123 submission. To check the output I have set up one message logger and one emailer on the output route in my automation. The message definition to the logger and the email body are identical, but the globalid is only written to the log, not to the email (where I get _undefined_) 

We recently upgraded to FME Flow 2024.0 and have been struggling with an issue where access to a number of our ArcGIS Server services is being denied at the Flow level.  We were first able to circumvent this by using on-network calls using HTTP however a recent job where we use a PythonCaller to geocode addresses is failing when we attempt to hit our Address Point Locator.  Job works as expected in Form, and we have ArcGIS Server working on the FME hosts, in addition to the ArcGIS Server host that has our working services. Has anyone else experienced this so we might know where to look?  Sounds like HTTPS/SSL but I am not sure where to begin to work with our Network Engineers.  Thank you,Nicholas 36 2024-4-2 14:19:09 | Message Type: fme::internal::_v0::py::Exception 237 2024-4-2 14:19:09 | Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.

Hello, I would like to automate a process on IFC files analysis in order to generate an Excel report per IFC file. To do this, I use the workspacerunner by giving a directory which contains all the IFC files to analyze. But I can't write Excel files in this same directory. I created an attribute containing the target directory name, but I cannot give it to my "destination data" transformer.How is it possible to customize the "destination data" transformer ?Thank in advanceBest regardsBruno

Hi, is it possible to upload a file to the FME Flow shared resource folder through the Flow REST API? I tried to setup a POST request for https://fme.oebb.at/fmerest/v3/resources/connections/<resource>/filesys/<path> but get a 415 Unsupported Media Type Response. I used the following parameters in Postman:In this example I want to upload the text file “test.txt” to the shared resource folder “Test”. Is there a problem with the request, or is this the wrong approach for uploading a file via the REST API? The goal would be to provide a means for external applications

Hi!I need help in configuring FME Form to run RCaller.FME is not local in my machine; instead, I'm remoting in to a server to run Form from there. It's prompting me this error message:    RCaller (InlineQueryFactory): Failed with exit code 1 when executing R script. Output was: Error in library("sqldf") : there is no package called 'sqldf'    Execution halted    Failed to execute scripted code.I followed the steps indicated in https://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/rcaller.htm. I configured the default paths and R Plugin files in: "C:\Program Files\R\R-4.4.1\bin\Plugins" and the Plugins folder contains the following files:    assertthat    BH    bit    bit64    blob

Hello Forum., This sounds like it’s a straightforward function. I’ve looked but can’t see an obvious way of doing it. I’m looking at FME Flow>Schedules>Manage Schedules. I want to be able to see the last time that a selected schedule item actually run. A bonus would be to see a successful/not successful flag too. Alternatively, this information could be captured in a log. But there doesn’t appear to be log option on that page, nor is there a column stating last time run. Or am I just missing it? Thanks,Stuart