Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Integration

Integration

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

1,021 Posts
3,593 Replies

When you subscribe we will email you when there is a new topic in this category

1021 Posts

Recently active

Most replies Most views Newest first

asked in Integration

Updating features through ArcGIS Portal Feature Service fails

Hi.I'm using the ArcGIS Portal Feature Service writer to do some inserts, updates and deletes on two feature services, one with line and one with points. The inserts and deletes works for both featureservices, but update on lines fails with the following error (operation rolled back for all of the features): 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: 'Operation rolled back., Operation rolled back.... There are about 2000 features I need to update, so my best guess is that the jsonobject for update is too large. The update works fine with up to 200 features. What would be the best alternative for updating the line feature service? One way might be to create some kind of loop to update 200 lines at a time, but how?

stljContributor

asked in Integration

FME Flow Stream connection to IBM MQ 9.3

Whats is the best way to connect to an IBM MQ 9.3 message broker from a workspace running as a stream on Fme Flow 2023? We need to be able to process several hundreds of messages/sec. I’ve done quite a lot of testing with the MQTT connector transformer and Mosquitto MQTT broker. Very fast and reliable. IMB MQ only supports AMQP 1.0 protocol and the question is if there is a connector transformer I can use for that? Fme Rabbit connector supports AMQP 0-9./Stefan Ljungstedt

john_gis4Contributor

posted in Integration

Views on recent FME price changes

I’m not sure if this is the right forum or category (I couldn’t select “general”), but as I’m sure you’re aware, Safe recently changed it’s pricing for FME, which includes annual maintenance pricing. We are a small consultancy business, long term Safe customer (10+ years) and have been FME advocates amongst our customers for many years. We have just received details of pricing for our annual maintenance in 2025 and for FME Form (previously FME Desktop Professional) for us this has increased by approximately 600%.The new maintenance price for FME Form is going to make it a lot more difficult to justify for a small business like ourselves.We were also previously lookng to expand our FME use by purchasing Flow, but the new pricing has also forced us to cancel those plans.We will also find it difficult to recommend FME to our customers, especially smaller ones, as the bar to entry in terms of pricing has been set so high.I have previously raised the issue of pricing with our reseller in th

markrmunozContributor

asked in Integration

CityWorks Web Connection

While attempting to set up a web connection to cityworks via FME/ESRI’s data interoperability externsion, the connection continues to result in “Unable to authenticate using the specified connection information”. We are on CityWorks Server 15.4.2 so the authorization token is set to be passed by query string. Any other changes or tips that we should try?

asked in Integration

SSL connect error

Hey all, I'm trying to do some webservice calls with the httpcaller. Unfortunately i'm getting the famous SSL connect error. I've tried setting the 'verify ssl certificate' to no but i'm still getting the error. I'm using FME 2020.1 and as an example i'm trying to do a get on the next endpoint/url:https://jira.atlassian.com/rest/api/latest/issue/JRA-9 My http caller settingsThe endpoint in the browser gets a nice Json back as response. The httpcaller however doesn't. The certificate is a wildcard certificate (could the be an issue?).Can anyone check it out if it works for them or if they get the same result? Just wondering cheers

errin_rowanParticipant

asked in Integration

FME unable to Post to Referenced Service in ArcGIS Entperise

Hello, i need some help here.I recently had my workbenches stop working. I am pushing updated into to referenced feature services in arcgis portal. I have re-created every reader, wriiter and parameter but cant get the same process to work again.I have made new workbenchs and new connection where i have just Readers and Writers (No Transformer) and i cant FME to push changes to featuer services.The error’s i am get is :ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Unable to complete operation.'. Details: 'No edits ('adds', 'updates', 'deletes', 'attachment edits', or 'asset maps edits') were specified.'BADNEWS: ARCGISPORTALFEATURES writer:Or“Could not find a layer/table matching the feature type”It Seem to JUST be a FME issues as i can access the Rest end point and use post to make edits, using fme i can update hosted serivces. It isnt a permssions issues and to my knowledge nothing has change on th

ridleyjContributor

asked in Integration

Why does sharepointOnlineConnector show only one web connection, when multiple are installed in the connections list?

I have had success in connecting to my corporate Sharepoint with the SharePointOnlineConnector using the web connection as set up in this HowTo: How to create a Sharepoint Web Connection (safe.com). Now I want to connect to another Tenant for which I have been granted access, but the connector only presents me with the Safe Template version for my web connection - even though I have set up and succesfully tested a new connection with a new name. I tried testing on a new machine, with no previous connections, and imported the new connection via xml then tried to add the web connection from within the transformer - same issue - the dropdown list doesn't show me the newly created connection (no matter what I call it):Can anyone advise on what needs to be done to connect from a selection of web connections for sharepoint?

asked in Integration

HTTPCaller: Upload binary attribute

Is it possible to upload a file as Multipart Upload without first writing it to the filesystem?I have this working:But this requires to first write the attribute to a file and then using the filepath to upload.I tried base64 encoding the binary attribute and uploading. But I dont know what to set the mime-type to._response_body (string: UTF-8): { "args": {}, "data": {}, "files": { "temp.zip": "data:application/octet-stream;base64,AAAAAAAAAAAAAAAA=" }, "form": { "token": "tokentokentokentokentoken", "f": "json", "archive": "true" }, "headers": { "host": "postman-echo.com", "x-request-start": "t=1722253286.223", "content-length": "201671", "x-forwarded-proto": "https", "x-forwarded-port": "443", "x-amzn-trace-id": "Root=1-66a77fe5-2101668c0d99d0fd01e61cc4", "user-agent": "FME/2021.7.42.21821 libcurl/7.79.1 (OpenSSL/1.1.1n) Schannel zlib/1.2.11 WinIDN libssh2/1.9.0 nghttp2/1.44.0", "accept": "*/*", "accept-encoding": "deflate, gzip", "cont

jp12212Contributor

asked in Integration

Hi, Just was hoping for tips on Converting DWG to GeoJSON - is there any one who can lend an explanation I’m attempting the below and it’d be great if someone could offer a high level understanding / approach.

alsherrenContributor

asked in Integration

Salesforce connected web app - web service configuration issue

Hi,I am trying to configure a web service to use the Salesforce Connector. When trying to test the connection, I keep getting error:error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration I believe this relates to the callback URI syntax, but I don’t know what it should be.. any ideas?

bingyParticipant

asked in Integration

Can FME Write ArcGIS Enterprise Attachments

Hi Everyone, Looking for some assistance, I’m using FME 2023.1.0.0 trying to migrate some existing Survey-123 forms and data with attachments from ArcGIS On-Line to our new Enterprise portal.Our survey-123 form has a singular photos field for tracking a picture of the bus stop, it also has a repeatable photo’s field (table) where the inspector is able to take and attach multiple deficiency photos to the stop if one exists. In FME, I’m able to read in the AGOL feature service that hosts all of the survey information, I’m also able to write out the tabular information from the point layer to the new Enterprise feature layer that was created when I saved the Survey-123 form in Enterprise.The part that I’m currently struggling with is getting the singular photos to attach when writing the tabular information out to the Enterprise feature service so when I view the points in ArcGIS Pro, they appear in the attachments tab of the attributes editor like they currently do with my AGOL service.

capizziemanueleContributor

asked in Integration

Publish IFC files as Scene Layers

Dear all,I have multiple IFC files in my folder and have to publish them as Scene Layers in ArcGIS using FME.Do you have any suggestions on how to proceed, and which is the best way to proceed? Many thanks.

lavanyaneeruObserver

asked in Integration

Azure Devops integration for FME

Hi Team, Can we integrate FME flow and FME server with Azure Devops using pipelines?

topotomaContributor

asked in Integration

Embedding an HTML Iframe in Arcgis Online Popup

Hello, I have been trying to figure out how to embed a website in ArcGis Online popups but could not get it to work.I have tried the method to have an attribute with the Iframe code as some suggested in earlier version it was interpreted correctly but it seems this is not the case anymore.I have found that there’s a way to embed video for example but nothing for integrating a website. So if you have any suggestion that would be great. Thanks.Thomas

marta.podsiadContributor

asked in Integration

Tester with Operator as a Parameter

Hi,I would like to create a workbench that will allow the user to make unique slecection from Excel document by entering not only value but also the operator. Is that functionality available?Example

ahmadrezakarimContributor

asked in Integration

SharePointOnlineConnector Multiple Download FIle

Hi everyone,I have an SHP file related to some parcels. For each parcel, there is a corresponding folder and contract (with the same name). My goal is to create a workspace based on the ready SHP files (using a simple tester transformation). The SharePointOnlineConnector should then download the corresponding contract from SharePoint and place it in a local directory.My main challenge lies in how to locate each contract. Currently, I’ve set up the SharePointOnlineConnector to create a list from the directory. Then, I use another SharePointOnlineConnector to download the contracts. However, during the second SharePoint transformation, I encounter an error:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/[my_share_point_name].sharepoint.com,3a2333c0-9794-425a-9978-a2eb613fc15b,c38a05da-86b2-48bd-a5b5-e80371d96e57/drives/b!nqLU0gc2Y0OJ_TIlc0aqVX_zKy7OiIFPltGPSW8STP_RoqJOec4jSbMoWXb1-7Y7/items/01MI2PLMPJAT7XK24RXZGJDFNW2D7PE4KR: The resource could

kersyContributor

asked in Integration

Executing FME Workbench Using Python Script for Batch IFC Processing

Hi everyone,I'm working on a project where I need to process multiple IFC files and write the data to a PostgreSQL database using an FME workbench. I've written a Python script to automate this process, which includes getting IFC input from the user and executing the FME workbench. However, I'm encountering problems when passing multiple IFC files to the FME command line.Any ideas? Main Idea:Getting IFC Input from User: The script prompts the user to enter the path to a directory or a single IFC file. Running the FME Workbench: The script constructs and executes the FME command with the provided IFC file paths and other necessary parameters.I am using a PythonCreator at the start of my FME script to catch these arguments and read with FeatureReader. Currently, when I look at the FME log after I run the external Python script, I see that the paths are not parsed as parameters. Main error I see in the log files is the following:2024-06-21 21:52:52| 0.4| 0.0|ERROR |ISO10303-21: Unable

danpeek101Participant

asked in Integration

ArcGIS Online Feature Service Reader Error

Hi All,I have written a workspace that downloads features (and attachments) from an AGOL Feature Service, and everything was working fine until about 2 weeks ago. Then it suddenly, and for no reason that I can see, stopped working. The error message is as below:2024-07-12 09:38:47| 5.7| 2.1|ERROR |ArcGIS Online Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='www.arcgis.com', port=443): Max retries exceeded with url: /sharing/rest/portals/self?f=json&token=3NKHt6i2urmWtqOuugvr9Xotftc2MEsOx2iLqu8k_LPVAUrx4ptneDwWq5gGHyWsx9gLJB14s-YhL9BcQ6A71ysFhsv00tTqKaTLWA9OxAioggyddpHKGcxUfwKFMnzU-m7-SshOGN98nlYOd2uB9-LSYOpHZbnxGUhNJ_3nnRQntaumsDD__7bZqpHVciIFHkLU-of9RGgQ17FdVaDRxF6HcXcbq9Sm4XmdkzD7LqM-h_2jGsOM8HOeFBSI6iINhlNJE65A50NL1eFOJ-gGgg.. (Caused by ConnectTimeoutError(<urllib3.connection.HTTPSConnection object at 0x000000001D666D10>, 'C

dbryantgeoContributor

asked in Integration

Executing vacuum in PostgreSQL via SQLExecutor

I have a workbench that imports a lot of data into PostgreSQL (~90m records across 3 tables, 1 containing spatial data) and we've identified a possible need to vacuum the tables. The data is "cleansed" post-import via a SQLExecutor that deletes data, creates data if necessary. However, we're unable to vacuum analyze (Analyze is fine) the data once that occurs as it appears that the SQLExecutor wraps commands in a Transaction Block - which means we cannot Vacuum. Any ideas on how we can perform vacuum via the SQLExecutor or have another strategy we can utilise? I am unsure whether using the writer's post-write execution of SQL in a parameter is performed before or after the VacuumAnalyze option that FME provides. I've seen some information around setting Autocommit to on/off within the SQLExecutor but this does not work in the newer versions of PostgreSQL. We are using an Azure managed database

asked in Integration

HTTP Caller POST To Add Attachment to Cityworks Work Order

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?

colejo02Contributor

asked in Integration

Sluggish performance with comment field

Hello, I am a first-time poster on the FME forum. My goal is to read data stored in a plain view from a non-spatial Oracle database and then write it to an Oracle SDE geo_dbtable. The issue is that my Oracle Non-Spatial Reader slows down, taking more than 30 minutes to execute the SQL Statement when I include two comment fields that are long, 2000 characters. When I run the same query in SQL Developer, the result is back in a few seconds. The log message that gets stuck on is: ORACLE Reader: Executing SQL Statement `SELECT…<field names> to obtain features for feature type <Oracle View Name>If I uncheck the comment fields in the User Attributes tab the reader returns quickly, within a minute. So I’m skeptical that it is caused by network distance. Given these challenges, I need some guidance. I’ve tried using an Oracle NCLOB to hold the comments in the view, but the result remains sluggish. I'm eager to learn how to optimize my workbench's performance when dealing with

willhwilsonContributor

asked in Integration

TCP\IP Receiver shutting down immediately

I am trying to set up a TCPIP Receiver to read raw data from a specific port on another host machine. On the box I am authoring the workspace with I can use Windows PowerShell to ping that location and have another technician confirm with Wireshark that data is being sent through this port. So in using the TCP\IP Receiver transformer I can ‘Successfully connect to host’ per the log but the translation immediately shuts down per the attached snip. Why is it doing this? It should be streaming data and to do so needs that transporter open. Thanks for any help.

saravanakumarSupporter

asked in Integration

Why user parameter value is not setting when i call fmw file from bat file?

Hi All, I am trying to call a fmw file using bat file which will run on fme quick translator. Here for a testing i created a fmw file with “path” reader and changing the input value as user parameter which i newly added in workbench. I created a testing bat file to call that fmw file but i am facing “Undefined environment variable”. I referred old case regarding and changed into ${variable} format but no change yet I’m facing the same. I attached workbench file and bat for your reference.I am using FME Desktop 2020.1.1.1 32bit version

danminneyatsafSafer

posted in Integration

OGC Geopackage Writer - copy feature type from reader imports incorrect geometry

When adding a Geopackage Writer to the workspace and using the “Copy from Reader...” functionality to import a feature type definition (from a Geopackage reader), the geometry set on the Geopackage writer feature type is incorrect.Upon opening the newly added writer feature type, it doesn’t show any geometry. Opening it a second time then shows the Geometry as <All>, which is not a valid value for the Geopackage format. We’re currently investigating the issue and will be filing a bug report shortly to get this issue resolved.

libocContributor

asked in Integration

Sharepoint term store and terms API

I would like to be able to update a Microsoft SharePoint term store and terms using FME. Has anyone done this using the httpcaller or any other method? Any advice would be greatly appreciated.

1
2
3
4
5
...
41

Page 2 / 41

Badge winners

t.yang_rmwbhas earned the badge Integrate Spatial Data
crystalatsafehas earned the badge Kanelbullens dag
ahuertahas earned the badge Welcome Back
chelseawuhas earned the badge Kanelbullens dag
dbaldacchino1has earned the badge English Speaker

Show all badges

29,799: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK