Integration

This workspace is meant to upload salesforce data into our Snowflake account. I created a connection With Snowflake and have my account name as the parameter. When I run the workspace, it gets all the way to the end with no errors but says that the transformation failed. My coworker runs the same workspace (connected to their own Snowflake account, both are under the same company mother account) and it works and uploads the data to Snowflake. I have not found any similar issues while searching online. What could be the issue?

I have been googling/trying to read about it but I dont seem to understand it too well. I dunno if I am trying to do something I cant. I am trying to use the UK Gov website (https://www.tax.service.gov.uk/check-council-tax-band/search) to search for council tax bands with a list of post codes. But the box to search the postcode sends the request and it appears to encrypt the postcode in the URL. Would it be possible to make it fill in this box and hit search? Appreciate any help as I am completely out of the loop here, never used the HTTP part of FME much. Cheers Also apologies if I have posted this in the wrong place!

Does anyone have a solution how I can decode a Bearer Token?

I am currently struggling to find detailed documentation on how we can add a custom project to FME, and simply use it with PythonCaller's, if anyone knows of a good guide for reference it will be much appreciated.

Hello everyone, I am trying to write a custom FME transformer using the FME Plug-in SDK with Java. I installed the FME Plug-in SDK and successfully followed the steps of the Java tutorial document (after installing the SDK, the tutorial document is located at '<FME>\pluginbuilder\samples\doc\FMEPlugInSDK_Java.pdf'; I attached it to this posting; especially section 4 "Installing and Testing a Transformer" is relevant to my question; ). In section 4 of this document the custom transfomer defined in file 'CenterOfMassCalculator_Java.fmx' is installed after installing, the FME workspace '..\java\test\function_test.fmw' is run which contains the 'CenterOfMassCalculator_Java' transformer as second element in the translation flow Eventually, running 'function_test.fmw' in the FME workbench results in that the method 'execute(.)' of the Java class '<FME>\pluginbuilder\samples\java\com\mycompany\myfunction\center.java' is executed. I am able to attach with the debugger of my IDE and track the c

I would like to automatize the listing and the downloading of issues on itwin platform. I managed to do the first part (i.e. the listing) by: adding a web service (using manage web services) let's say itwin and creating a web connection foe the newly created web service Using a httpcaller with this web connection in the authentification method, I can obtain the list of all the issues for a specific project with a get call, using the query https://api.bentley.com/issues?projectId=$(projectId) Regarding the next step, from the documentation, I have this query https://api.bentley.com/storage/files/fileID/download How should to make this query work so that I could download an issue?

Today I was helping one of the users in my organisation with some code in a PythonCaller. The value returned by fmeobjects.FMEFeature.getAttributeType — Python FME API FME 2023.0 b23309 documentation (safe.com) is an integer. The list of possible values is defined by the list of constants here Features — Python FME API FME 2023.0 b23309 documentation (safe.com) What I am missing is which constant represents which integer value. Are these available somewhere? This would have been helpful understanding me and my user what was happening.

I've followed this article https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0 Initially I was able to read features. I've come back into the workspace after a week and I'm getting this error Type: 4, Number: 1, Message: Failed to get authorization query string.Updating access token for 'WebServiceSanDiego' JSON Error: refresh_token expired Unable to update access token for 'WebServiceSanDiego' I've re-tested by webservice by going to preferences, manage service and test (requires you to login), but it's still not working. I would assume I'd only have to set this up once and it would refresh itself going forward, or is this something configuration wise on the portal end? Note, this is something setup for us to connect to by a customer. Is there a more ideal suggestion for ongoing integration? Read/Write

Hi @daveatsafe​! I am trying to use the Maximo object updater but I am missing the existing object url. Per the documentation I can use the Object Querier the problem is that I cant seem to figure out which attribute to use as there are several url lake attributes. Any thoughts/ guidance that you can provide would be amazing. Thanks so much in advanced. G

I am trying to set up a KafkaConnector to read from a topic. For the SSL certificate, I provide a keystore that I've used to connect through OffsetExplorer, but it is unable to retrieve the topics. Does FME expect a different type of certificate? I get the following error: An error was encountered while retrieving existing topics: 'Failed to create admin client: ssl.ca.location failed: error:0B084088:x509 certificate routines:X509_load_cert_crl_file:no certificate or crl found'. Please check host names and ports, security settings, and credentials

I want to write a different json file for every time window defined in my TimeWindower. To make things simple I'm using the window number as the window ID attribute (when I manage to make it work like this I'll use the window start time). I want to write the data in each time window into a different (json) file and to name them I want to use the window id attribute together with some other string. Right now the first file (string_0) is output as expected but the workspace will only output 2 json files for a total of 4 time windows (I used a terminator after the 4th time window) and the second one is not properly closed. Any idea of what am I doing wrong?

Hello! this is a long shot, but I hope I might find some help here. Is there a way using FME to write Operational layers to enterprise web maps? If you are familiar, there are widgets, like the Drew, which produces an operational layer, which is actually a temporary layer. I would appreciate any kind of help. Thank you!

In a Esri ArcGIS Portal Feature Service that we are processing some of the GlobalID's are in lower case without the culry brackets. When FME reads these GlobalID's the case is being changed and brackets are added. Hence the GlobalID "26565f7e-615f-43a6-8333-e156adc7cb46" is read by FME as "{26565F7E-615F-43A6-8333-E156ADC7CB46}". One problem comes about when FME can't update this feature using the GlobalID because FME as reformatted the GlobalID. This problem is verified by using FME to change the case of the GlobalID to lower case and removing the curly brackets which then allows the feature update to occur. My question is, how can I get the Esri ArcGIS Portal Feature Service Reader to read the GlobalID's without reformatting?

I'm trying to bulk insert features (Append) data (basically merge databases content) to existing destination Feature Service using the FME_ArcGIS_Portal web authentication for web service. I noticed that the Features Per request parameter has an odd behavior, and I can't seem to control/change that physically on ArcGIS Enterprise side. In the snapshot, if I leave the default to 1000, or reduce to 500 features per request it gives two different errors. ERROR |ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was 'None' and the message was: 'Could not access any server machines. Please contact your system administrator.'. Details: 'None' or ERROR |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', or 'attachment edits') were specified.' If I set to 449 just less than 500, it

Hi FME community, I am trying to start a job on FME Flow from another application by making use of a webhook and a token. The trigger results in succesfully starting a job on FME Flow, but the response is most of the time the following: 502 - Web server received an invalid response while acting as a gateway or proxy server. It looks like this only happens when the job takes longer than 2 minutes. Does anyone have an idea where the 502 response comes from? This indicates an error while in fact the job is started as expected. Version 2022.2 Build 22765 - win64

Hi there, I'm trying to Update a Scene Layer in ArcGIS Portal for Enterprise. While I'm able to delete the existing Scene Layer, update the existing Scene Layer Package and sharing it, the step of publishing fails. The error Message is: PUBLISH_ERROR There was an error while publishing the item: ERROR 000800: The value is not a member of SHAPEFILE | CSV | SD | SERVICEDEFINITION | FEATURECOLLECTION | FEATURESERVICE | MAPSERVICE | FILEGEODATABASE | SQLITEGEODATABASE | SCENEPACKAGE | GEOPACKAGE | GEOJSON | TILEPACKAGE | VECTORTILEPACKAGE | EXCEL | COMPACTTILEPACKAGE. Failed. I can select the Scene Layer Package in the ArcGISOnline Connector. If I publish the Scene Layer Package, that I uploaded with FME, directly in the Portal, it works fine. A Scene Layer (hosted) is produced. However, if I try it with the ArcGISOnline Connector it fails and produces an empty "Feature Layer (hosted)". I think this could be somehow the problem. It tries to produce a Feature Layer instead of an Scene Layer

I wan to connect to a REST-API with a WebConnection (Token Service), but it doesn't work with the paramters i use. The same parameter in a HTTPCaller are working. Any Idea whats wrong? The token is assingned to the key "jwt". I use FME 2023.1. Example Settings for the HTTPCaller Request URL: https:www.test-example.com/backend/api/AUTH/login HTTP Method: POST Headers: Accept text/plain Upload Body: {"email":username@test.com, "password":"12345"} Content Type: JSON (application/json) And the answer looks like (the values are not real) { "user": { "id": "123qw14-a666-222e-777a-a123fg2f12ad", "email": "usename@test.com", ... }, "jwt": "0a80da980d80a7f7sd073", "userConfiguration": null, "globalConfiguration": { "tileApiKey": "123sdgf43254e6sZZU347" }, "maxTables": 8, "maxColumns": 50, "language": null } My Web Connection Settings are like this: Request URL: https:www.test-example.com/backend/api/AUTH/login Request Data: email[username@test.com]&password[12345] Token Object Key: jwt Placemen

Hi everyone, So basically, my workflow has a httpcaller to make an API call and let's say the call returns a text "yes" or "no" but it takes a while for the call to be completed to return "yes". That's why I wanna do a for loop to make the request every 5 mins until "yes" is returned. Please let me know how I can do this or feel free to suggest a better way if possible. Thanks so much!

I've walked through all the steps found here to connect to our Enterprise portal: https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0. I created an application on the portal, made a new Web Service from the default Portal template, but I can't get past the Authentication of the web service, every time I test it I get a 404 error. Has anyone encountered similar issues before?

Hello all, I am trying to update a feature layer on the ArcGIS Enterprise Portal. I have the feature layer and an Excel I'm using for the updated information. The change detector detects the one change I've added to my test version but when I try to update the online layer I get this error message: "ArcGIS Portal Feature Service Writer: 'updateResults' error for a feature in 'C1_Cluster_Flurstueck'. The error code from the server was '10500' and the message was: 'Cannot convert a value of type 'java.lang.String' to 'INTEGER'.'" The values that I'm trying to update in the excel and in the layer are both text fields and not numerical hence I dont understand where the integer part is coming from. Can someone tell me if I'm using the right transformers and what I should change to make it work? Thanks in advance! (I'm fairly new to FME so any help regarding the workspace is appreciated)

I have a table including some file name and I was wondering if ther is a transformer or work flow can read the file name from the table and download them from the local server to my computer.

I am snapping points to line based on unique id (using group by). I tried using both vertex snapping or segment snapping. In both of these case, the points are being snapped to endpoints in some cases ( as per screenshot). I don't want to snap the point to endpoint at all, but it can be anywhere on the line. How to achieve snapping the point on the line other than endpoint of the line? Thank you

Hi, We are trying to connect zo an Azure postgresql database via oatuh2.0. Does anyone know if this is possible? Oauth2.0 is available for web service connections. kind regards, Fran

Due to certain circumstances, primarily due to a limitation within ESRI, I find myself in the situation where I must retrieve data from my database not directly via the sde reader, but rather indirectly through the postGIS reader. Despite encountering various challenges along the way, I managed to surmount these obstacles. However, the primary issue I currently face involves the resolution of domains in my output. Naturally, the postGIS reader does not offer an immediate solution for this matter. My consideration was to take an alternate route, yet I am encountering difficulties here as well. My proposed approach involves extracting information from the domain tables and subsequently configuring it using AttributeManager. Regrettably, I am unable to locate the domain tables within postGIS. I hold the belief that these tables must exist within the postGIS setup, albeit their exact location eludes me. Any form of assistance in this matter would be greatly appreciated. Thank you for your

Has anyone ever used the Wrike API in FME? I'm reading the docs and trying to figure it out but could use some help on how to get a token and then query data within tasks: OAuth 2.0 Authorization | Develop your own integration on the Wrike API