Skip to main content
  • EN

Integration

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

  • 1,180 Posts
  • 4,184 Replies
1180 Posts
danminneyatsaf
Safer
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. 

791
danminneyatsaf
Safer
liboc
Contributor
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.

1051
hkingsbury
Celebrity
barisguner
Contributor
barisgunerContributor
asked in Integration
Zoom Level Limit in Geometry Parameter

Hi,Is there a hidden Zoom limit which can be changed in the Geometry Parameter setings which prevents users to zoomin further than a specific level like (z21 in Google)? Or is this a “feature” of the Leaflet source code behind the this function? I can understand the limit for Google Maps but when using our own custom WMTS layer we shouuldn’t be stoped by this limit. And no  I cannot see any references to this in the online doco:  https://support.safe.com/hc/en-us/articles/25407744364941-Using-the-Geometry-ParameterCheers,Baris

1012
LizAtSafe
Safer
thomastupuivao
Contributor
thomastupuivaoContributor
asked in Integration
SQLEXECUTOR cannot be evaluated without a feature error

I have a filegb that I want to append a value from an oracle non-spatial dataset where the address and postcode match. But keep getting the error “The SQL query contains an expression or a global parameter so cannot be evaluated without a feature. Please run translation instead.” Any ideas please how I can resolve this? 

663
geomancer
Evangelist
spatialexjames
Contributor
spatialexjamesContributor
asked in Integration
Is deleting from a Google Shared Drive supported?

I have been trying to automate uploading/deleting from a Google Drive Shared file using a GoogleDriveConnector, which I thought was recently changed to support shared drives. The first issue is that the files do no automatically overwrite if they have the same name, they create duplicates, whereas if you upload manually the files will become versioned. To get around this, I assumed I would be able to identify and delete the older file first before uploading the new file, however when trying to delete the older file I get:"2021-10-20 15:19:39| 21.6| 0.0|INFORM|Delete_existing_file: Object with id "File ID" does not exist on Google Drive. Nothing to delete". (I have removed the ID for this post). I have permissions to delete from the drive, and I have created the shareable link manually as a check to confirm that the file ID is correct and exists. I can successfully upload new files to the said folder, but I'm trying to avoid a scenario where I have a load of outd

394
rzel24
Contributor
saravanakumar
Supporter
saravanakumarSupporter
asked in Integration
trigger mail when my workbench face error in fme forms?

Hi All, I would like to know thatis there any possible way to trigger mail while running my workbench in FME Desktop/ Forms if it is facing a error?.FYI : I am using FME Desktop 2020.1.1 version. Thanks in advance!

536
saravanakumar
Supporter
myadegaryiutac
Contributor
myadegaryiutacContributor
asked in Integration
_response_body is not in JSON format

HiI am using the HTTPCaller to get the information from Issues page in Autodesk Construction Cloud (ACC).The AuthorizationToken has been created and looks good but once I am using HTTPCaller to get information form issues page,  the result created in “_response_body” is not in the json format so consequently I am not able to use JSON extractor Is there any step that I am missing?P.S:In “HTTPCaller4”in requested URL I used “https://developer.api.autodesk.com/docs/issues/projects/$(PID)/issues”*I have predefined $(PID) in User Parameter. In Header I used “Authorization Token” created in 1st stepThanks

1387
jkr_wrk
Influencer
kersy
Contributor
kersyContributor
asked in Integration
OpenAI completion transformer to support non-deprecated models

The completions API models were deprecated at the beginning of 2024. The current version of the transformer does not have model options like gpt-3.5-turbo. Will there be more options for models in the near future from FME's side?   

981
danminneyatsaf
Safer
alanaliberti
Contributor
alanalibertiContributor
asked in Integration
kml placemark name as output dwg layer name

Hello allI’m trying to achieve the above, so far I’m struggling on how to find out the KML reader ‘placemark name’ property, to write it as a DWG layer name.Could anyone point me out on how to do that? Thanks

835
liamfez
Influencer
oscarw
Participant
oscarwParticipant
asked in Integration
Blocked from connecting to ArcGIS Online services

Unable to connect to ArcGIS Online services through FME Form. This issue began at approximately 4pm AEST on 5th June 24. No connection issues were apparent earlier in the day. Can anyone suggest a solution to this? I’m unable to add a new connection or use an existing.Wondering if this is an FME or ESRI issue?Updating access token for 'BCT Enterprise'JSON Error: Access to this application has been blocked. Please contact your administrator to allow access to this app.Unable to update access token for 'BCT Enterprise'Python Exception <FMEWSException>: Type: 4, Number: 1, Message: Failed to get authorization query string.An error has occurred. Check the logfile above for detailsMany thanksFME version 2023.2.2.0

1582
oscarw
Participant
2eight
Contributor
2eightContributor
asked in Integration
Excel writing issue

hello i am trying to write something in excel format but the result are like in the picture, how to write the data from the start of each rowplease suggest 

926
hrgisolutions
Contributor
capizziemanuele
Contributor
capizziemanueleContributor
asked in Integration
Read REVIT/IFC files and create ArcGIS Web Scenes

Dear all,I need to add multiple REVIT/IFC files into an ArcGIS WebScene. I am trying to determine the most efficient way to achieve this.From my understanding, the process should involve the following steps:Read multiple REVIT/IFC files from a given folder. Transform these files into Multipatch and save them into a Geodatabase. Publish the layers.Do you think it is feasible to obtain such a result?Many thanks.  PS: I found this post which contains a similar request: 

530
capizziemanuele
Contributor
fmejamesl
Contributor
fmejameslContributor
asked in Integration
JSONUpdater Ssts all to last value processed

***UPDATE - PROBLEM RESOLVED***This is a strange one!For this example, I have 2 features. I put a counter to get 0 and 1 for the value. Then I’m updating my JSON with the _count value. The output from the JSONUpdater has SERIALNUM = 1 for both features. If I change the sort, it will set both to 0. I’m passing in the same feature in the Document and Update input ports. I’m not sure the distinction between the two input ports.  

532
danilo_fme
Evangelist
serg42932
Contributor
serg42932Contributor
asked in Integration
Add Cityworks Inspection attachments using FME Form

Hi, I am trying to add Inspection attachments to the Inspections using FME Form.I have excel spreadsheet that have EntityUID, InspectionTemplateId, Observations Questions and Answers, and image links1 - to image link4(attachments)Each Inspection must have entity attach to it based on the EntityUID. Image as JPG extension located on the repository an each image have EntityUID in the image name.How can I attach image to the Inspection- that is first questionSecond question is that some Entities have up to 4 images related to them, that reference based on the different parameter (Image_link1, image_link2,image_link3, and image_link4)  It is easy to create inspection, add entity, and populate Observations questions and answers but I am struggling to attach the images. 

1063
serg42932
Contributor
harish
Contributor
harishContributor
asked in Integration
Here Maps XML to CSV

I have Here Maps Data in XML format. I want to extract the data to CSV in FME. If I am directly adding XML there are issues in reading the file. Currently I am using an XML Flattener tool built using python. Is there any option in FME to do this?

393
geomancer
Evangelist
wlsuhr
Contributor
wlsuhrContributor
asked in Integration
Esri ArcGIS Portal Feature Service Not Preserving GlobalIDs on Insert

I'm trying to write new (Insert) features to a Utility Network feature service using the Portal writer and it doesn't appear to be preserving global ids despite my parameter setting to do so. The issue appears to exist on all layers in the service. I've tried connecting to Portal via 'Web Connection' and with 'Generate Token' parameters and see the same result. I am connecting to a branch version and not DEFAULT. I can confirm that Globals are not coming over as expected on the version.I've got some Fiddler screengrabs as well if that's helpful.Thanks all.

964
wlsuhr
Contributor
pratap
Contributor
pratapContributor
asked in Integration
CIM Version

Hi All, https://support.safe.com/hc/en-us/articles/25407773286157-FME-CIM-XML-for-Electric-Utilities The link mentioned above offers valuable insights about the process of transferring data into XML format specifically designed for CIM electric utilities.  Upon constant verification, "61970cim18v02_61968cim14v00" is mentioned in cim.xsd file. This seem to indicate that the CIM version is of version 14 (version 0)? I am seeking assistance to determine the specific CIM version associated with the link provided. Understanding the appropriate CIM version is crucial for ensuring compatibility and seamless integration within the current system. Your guidance on this matter would be greatly appreciated, as it will streamline the process of identifying and implementing the correct CIM version, thereby enhancing the overall functionality and efficiency of the system. Thank you in advance for your support and assistance in clarifying the CIM version associated with this link.

721
AliAtSafe
Safer
henriquereisgeo
Contributor
henriquereisgeoContributor
asked in Integration
ArcGIS Online (attachment photos) to GDB

Hello all, I am trying to use “reader” AGO data to provide a “Writer” GDB which contain the attachment photos I have been advised to use this process:In the “reader” I set up o include attachment:and selected the attributes: Set up “AttributExposer” In “RasterReplacer” I am not usre what should be done:  When I try to select “Data:Became unable to process:   I have been advised“ It seems you missed the last step in my first response.   "The arcgisonline_attachment{}.data attribute holds the raster data which you could then use the RasterReplacer to recreate the image."You should add RasterReplacer to restore data into an image and then use a writer with the correct format (which you selected within RasterReplacer) to write those output.” Does someone one know what to do? ThanksCheers

2923
AliAtSafe
Safer
daniel.m.getz
Contributor
daniel.m.getzContributor
asked in Integration
What would cause a Snowflake connection to work on FME Desktop/Form, but hang on FME Server/Flow?

I have a snowflake connection that works perfectly on desktop, and most of the time hangs when I push it to FME server. My connection to snowflake is a service account with a username and password. I am using the SQL executer transformer to run a query against a table of shipping data in snowflake. I have also tried the workflow with the Snowflake Non-Spatial Reader, and the feature reader.Running it on desktop is no problem. Just about any query I throw at Snowflake returns data, even up to 700k+ rows. When I publish to server, the job almost always hangs up right at the point where the query is submitted. I say almost because when I shrink the query down to just 1 or 2 records returned, the job will return that data. Based on this information, I am assuming my connection between my FME server and the Snowflake instance is good. Any thoughts as to what could be causing the jobs to hang?  FME desktop version 2022.2.1FME server version 2022.2.1

821
hkingsbury
Celebrity
nicol.ricci
Contributor
nicol.ricciContributor
asked in Integration
Consume FME Apps using token

HiIn production environment i have FME Server  that has a SAML Configuration and it works fineI created an APP in FME.This app need to be under authentication and i set the users in the configuration. The problem is that this APP is included in sharepoint page using IFRAME. The users are authenticated in Sharepoint but when they  access to the page that contains the FME App, the app shows the login page. If the users click on SAML Auth button, the IFRAME try to show the provider's sign-in page that is not setted to be included in IFRAME and so it doesnt’ work.So to solve this problem, i tried to create a token and tried to call the app in IFRAME passing the token in the query string. But it doesn’t work.So the question is: there is a way to display an APP using token instead of user credential?

530
nicol.ricci
Contributor
01011010
Contributor
01011010Contributor
asked in Integration
Stop zip file from being split

It is possible to the saved zipped file from the ShapeFile feature wrtiter NOT split (generate) multiple zip files. The workbence/job is running on FmeCloud.  

361
andrewj74
Supporter
martin_k
Contributor
martin_kContributor
asked in Integration
SDK FME 2024 in C++: files for pointcloud missing

We use the SDK in C++. When migrating our code to FME 2024, I realized that several files related to pointcloud cannot be found in the new SDK any more.The only file I can find for pointclouds is pointcloud_fwd.h. But when using an IFMEPointCloud pointer, the declaration cannot be found. The files that I used in earlier versions of FME do not exist any more (ipointcloud.h, ipointcloudblock.h, ...)Where can I find these declarations now? Is there an example for C++, how the point data of a pointcloud feature can be extracted with the SDK of FME 2024? 

883
martin_k
Contributor
georajesh
Participant
georajeshParticipant
asked in Integration
Publishing multiple items inside a file geodatabase to AGOL(Bath Publish)

Hello,I’m working with the ArcGIS Open data portal and I want to publish all my layers within a geodatabase to my AGOL folder as new Feature Services. Since there are multiple items(layers), I’m looking for a batch process. I’ve came across several transformers but none of them seems like working for me. I would appreciate your suggestion on transformer selection for this.Thank you.Rajesh

380
georajesh
Participant
hawaiialex
Contributor
hawaiialexContributor
asked in Integration
Integration between Feature Class and Asset Management System via API / Change Detector

 Hi Everyone,I’m working on an integration workflow between an editable polygon feature class in an enterprise geodatabase and an asset tracking the same asset in an Asset Management System (which will be where the majority of the info is populated). We cannot write directly to the Asset Management System database, and need to write/get to it via API.The GIS feature class has a few attributes that are not in the layer in the Asset Management System and vice versa therefore it is not a straightforward cloning. That being said, I will have the attributes/fields required in the GIS Feature layer already so that new fields/attributes themselves don’t need to be created in the FC. However, we want to set up an integration as the diagram shows above.So the lifecycle of the asset will start in GIS, whereby a user will trace out a polygon in GIS and the fields such as Geometry, Object ID and Asset ID will get autogenerated as a result. The user would then fill out the few GIS only fields in GI

330
hawaiialex
Contributor
robertr
Contributor
robertrContributor
asked in Integration
fme.exe is using a file from Python Startup Script - crashes the script

Hello,I have a situation that I cannot seem to understand.It seems that fme.exe is locking/using a file that I try to rename in the Startup Script, although that file is not used at all in the workspace (the processing where the file gets created/saved/renamed is happening in the startup script).The logs don’t mention this file/folder as being used at all.i don’t have the file open in any other app, closed everything else except FME.This is happening on windows.  Logs say:2024-05-24 11:32:20|  18.7| 18.5|INFORM|15160 fme.exe is using C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx2024-05-24 11:32:20|  19.1|  0.0|ERROR |Python Exception <PermissionError>: [WinError 32] The process cannot access the file because it is being used by another process: ‘C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx’ The interesting thig is that on another machine with the exact same setup (both for python and fme) it does work without any issues. I checked the debug file for both, the o

531
david_r
Celebrity

Badge Winners

Show all badges

Community Stats

31,802
Posts
120,809
Replies
39,420
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.