Integration

I am working on using a webhook from our accounting system (Xero) to trigger an FME job. I've worked with triggering FME tasks (FME Cloud) many times before, successfully.  One of Xero's requirements is that the webhook endpoint return an empty body when using the webhook - is there any way to configure fme to just return the standard 200 status code, but have no body in the response? Current url being used for the post request from Xero:https://[acct].fmecloud.com/fmejobsubmitter/[repository]/[workspace].fmw?token=[token]&opt_servicemode=async&opt_showresult=false&opt_responseformat=jsonBody being received from that POST request:{  "serviceResponse": {    "jobID": 2999,    "statusInfo": {      "mode": "async",      "status": "success"    }  }} Webhook requ

Hi there. Iam trying to do a workspace to combine values/attributes from two different lists/objects. Idea is that there is always 1 parent ”object” and 1-x child ”object(s)” under the parent ”object”. The software that i am using to make these objects gives a unique identifier number for the parent object, for example ABC1. Software also gives a unique identifier number for child object by using the parent identifier + adding a letter after that, for example ABC1_A, ABC1_B and so on. The problem that i havent solved is how to combine and make new attributes by comparing parent and child object indentifiers. If the child object shares the main part (ABC1) of the identifier number it should have get the values from the parent and merge them with the child attributes/values. So, for example child objects ABC1_A, ABC1_B, ABC1_C, ABC1_D all gets attributes/values from parent object by shared parent id ABC1. New, combined attributes has values from parent objects and child

Hello, We are evaluating FME Desktop for a client. We are not clear on mechanism by which FME desktop will integrate with client's active directory.Please note that client uses trustbuilder as identity provider.Questions:1) What mechanism does FME Desktop provide for integrating with trustbuilder?2) What mechanisms does FME Desktop provide for integrating with active directory (if it does not provide integration with trustbuilder). Thanks for your time in reading this question and replying to it. Best,Amit  

Hi everyone, I'm using FME Desktop 2020.2 and I'm trying to create new web services, in the "manage web services" window, from Google Gmail (safe.xxx) and Google Sheets (safe.xxx), because Emailer transformer and Google Sheets Reader v4 want connections from these web services. I realized that these type of services are not shown in the choice list. I need to create new services because I want to use my own Google App (with related ID and Secret) and I don't want to modify the default web services provided by Safe Software. Any suggestions? Thanks

Spend a couple of hours investigating why a single Polyline Feature won't append to an existing FGDB feature class. It turns out because it was very long, the initial spatial index created is too small to manage the number of grids that this long polyline traverses. Never seen this before in a GDB! An error occurred while flushing the cursor for the table/feature class 'LateralsGeometry'. The error number from ArcObjects is: '-2147216894'. The error message from ArcObjects is: {The spatial index grid size is invalid.}Some error has occurred during shutdown of the writer, see previous errorSome error has occurred during shutdown of the writer, see previous errorSome error has occurred during shutdown of the writer, see previous errorFeatureWriter_4 (WriterFactory): Some error has occurred during shutdown of the writer, see previous errorSome error has occurred during shutdown of the writer, see previous errorTranslation FAILED

I've tried to download it as in Article Making RGB Images with Sentinel Data (https://community.safe.com/s/article/making-rgb-images-with-sentinel-data) but in sentinel public image browser sentinel-s2-l1c > tiles > 10 > U > EV there's no folder 2015 and available data. Is there another localization where I can download Sentinel images in jpeg ?

I have citygml Lod2 data and 2D shapefile of buildings of same area. How best can I store these two data and integrate so I can query to get info from both the 3d and the 2d data when I visualize in a web application like cesiumjs?

I would like to see if anyone can help me figure out a way to export data from https://fortress.wa.gov/wsp/collisionanalysistool/Query/SearchCriteria site using either HTTPCaller with JSON... or another series of transformers.This site allows us to select collision data based on some criteria and then export that data out to excel/csv. I have requested the API reference to this, but have not yet received it, and am not sure if I will.Ultimately I would like to automate a process that downloads most current data on a monthly basis then adds that data to a GIS layer.It seems very doable; but not being a web developer, I can only get so far trying to understand what's going on using developer tools in Chrome/Edge.When using HTTPCaller, the response body looks promising, but I can't seem to get past that.Any help would be greatly appreciated.

I have the following table in SQL Server 2016CREATE TABLE [dbo].[new_tasks]( [id] [uniqueidentifier] NOT NULL, [reportedDate] [datetimeoffset](7) NOT NULL) When I run the following SQL in MS SQL Server Management Studio or via an SQLExecutor it correctly inserts the time value into the database. INSERT INTO new_tasks([id],[reportedDate]) VALUES ('F59DA401-DE8F-4F3C-A60C-018008D81527','2019-10-24T13:57:48.076178+11:00') I.E When querying the record the reportedDate will be returned as '2019-10-24 13:57:48.076178+11:00' But if I try and insert the values using the FeatureWriter it will zero out the offset, I.E. reportedDate will be returned as '2019-10-24 13:57:48.076178+00:00' Converting the datetime string in a workbench to FME datetime or FME datetime with offset, correctly transforms it inside the workbench, but it will still zero out the offset value w

Is FME server is flexible enough to be integrated with the monitoring tools such as Splunk ,. Dynatrace , kibana .. etc. Can the monitoring and manipulation of the batch jobs integrate with tools such as CA7?

Hello everyone,I'm using FME REST API V3 to retrieve some FMEParameter informations, however it seems that the Configuration part is missing in the response: I only have these information in REST APIIs there another REST call that will give me the Configurations info for the FILENAME_MUSTEXIST parameter? Thanks

Hi, we havw installed the FME Server just before few weeks, so we are beginners. I published the workspace into the fme Server and wanted to run the workspace. After directing to correct Respository, workspace and Service Download, I added a Published Parameters: Source- from My Folders in PC-per Temporary Uploads, (Adressen). I could also run a workspace, but anything happend, and after some time this "Information" appears.  I am not sure what to do, in this case. How or if to do something? 

I have a script that uses excel reader and writes into a SQL database. It works fine but one issue is that a field I'm trying to copy has a 'version number' such as 5.1.01 or 5.3 where 5.1.01 is coming out fine but 5.3 is appearing in the db as 5.29999999 as shown belowThe version column is set to 'Text' in the excel sheet.The excel reader is using the 'char' type as shown belowThe writer is set to use the 'nvarchar' type as shown below, which is the same as the type in the database 'nvarchar(255)'It appears somewhere in the proc

Hi,I found the perfect python script for my needs on the net the other day.For the first time I wanted to use the pythoncaller.However the input for my caller is a matrix.I'm pretty sure my matrix is correct as well as the script i want to use. I don't have a clue how to match them.Any ideas? The script I want to use is this one:# Python program to find all# rectangles filled with 0 def findend(i,j,a,output,index):x = len(a)y = len(a[0]) # flag to check column edge case,# initializing with 0flagc = 0 # flag to check row edge case,# initializing with 0flagr = 0 for m in range(i,x): # loop breaks where first 1 encountersif a[m][j] == 1:flagr = 1 # set the flagbreak # pass because already processedif a[m][j] == 5:

Hello,I am trying to setup my web service and a web connection for the Sharepoint online connector, and have downloaded the FME Hub package safe.microsoft-sharepoint-1.0.0.fpkg. I have successfully used the default values supplied with the package in my FME desktop environment, and have setup an FME process to use multiple actions from the sharepointonline connector - which will simplify my organisations workflow in this area greatly. However: I need to configure this to run on FME Server 2019.0 and have registered an app on azure for FME, and have my client ID and client secret. I have updated the URL parameters in the webservice setup in FME to point to the tenant endpoints e.g. https://login.microsoftonline.com/<my tenant ID>/oauth2/v2.0/authorize.I'm not sure what my redirect URI on the webservice setup page in FME is doing but I've set it to this:

I am trying to use the Microsoft Dynamics 365 web connection in FME. I am unsure what username and password need to be input. I was working with one of our administrators of the product and he provided me the organization, client id, client secret, and resource. But he thought that user name and password were no longer used to connect to a D365 API. I'm trying to connect to non-spatial data in Dynamics and then write data from it into postgres. We're going to use FME to convert lat/long columns to geometry and add a spatial index while the data is in-flight.  

ArcFM autoupdater in not invoking ​on feature create event using fme. in start up python script initializing arcfm license. I could see arcfm system autoupdaters are working but custom AU which is assigned in feature on create is not firing. Please help

The WB reading fgdb from UNC path , I tried to read from local machine same error, read different data same error .

Hello,I am currently working with some scooter mds data and I am trying to find references to help with pagination. I would like to be able to call page one and use a json fragmenter to process and then go onto page 2, etc. Has anyone worked with something like this before or has some ideas? I'd love some input.The API has links in the json that have "first", "next", "last" that reference the corresponding page number.My thought was to keep referencing the "next" page url for processing until the last page: It looks a little like this: next: http://(scooter provider mds)trips?end_time=(date/time)&page=2&start_time=(date/time) http://(scooter provider mds)trips?end_time=(date/time)&page=3&start_time=(date/time)

Hi Guys, I have closed multipacth building models. What I would like to do is distinguish verticals (i.e walls) from horizontals (i.e roofs). I tried to deaggregate geometry and calculate the vertical area of features (hoping to identify walls) but instead of getting vertical, I have verticals with horizontal components (like L shape surfaces).  I was wondering if anyone knows a better solution to this problem ?  Regards,  Engin

Hi all, We are currently going through a process of creating our GIS system and currently choosing between the Geocortex solution or Esri Portal. In regards to FME, is there solutions which they have a better link with? Is there anything which has concerns with or both solutions fine for FME to work with. The reason is we have huge amounts of FME workbenches but I notice both solutions have their own workflow systems. Also what solutions are used and prefered by users on here?

I am trying to set up a Spatial Data Warehouse within a geodatabase. How can I get FME to create and maintain a running-integer surrogate key for my feature classes and tables? The surrogate key is a replacement for the primary key that has to remain unique and should be in a running integer format for every new row inserted into a feature class (e.g. 1, 2, 3, 4, ... 101, 102, 103).

Hello,Situation:I have 2 cameras for crowdcontrol. Measures people (walking, cycling) going in/out a certain area. Those cameras generate a stream that I can access through FME. This stream is in this format:When the stream is complete (or the timewindow is reached) we get an EOS (End Of Stream) thus the WebSocket connection can be closed. Is that possible?Because when connection is still open it does not write the output to a Writer. Database/Plain text file/.... I can only see the output with a logger.  

Does FME support connecting to Azure SQL Data Warehouse or Snowflake? We want to be able to connect to and move data from either (or both) of those data sources into postgresql.

If I am using the HTTPCaller to send large amounts of data to server, it adds a Expect: 100-continue in the header of the request. Our server doesn't know how to respond to that and is causing problems. Is there any way to configure the HTTPCaller to not add that header?