FME Form

I get a response from an API GET request in JSON and it contains the coordinates for a polygon.{"authenticationResultCode":"ValidCredentials","brandLogoUri":"http:\/\/dev.virtualearth.net\/Branding\/logo_powered_by.png","copyright":"Copyright © 2022 Microsoft and its suppliers. All rights reserved. This API cannot be accessed and the content and any results may not be used, reproduced or transmitted in any manner without express written permission from Microsoft Corporation.","resourceSets":[{"estimatedTotal":1,"resources":[{"__type":"IsochroneResponse:http:\/\/schemas.microsoft.com\/search\/local\/ws\/rest\/v1","dataSourcesUsed":[5],"origin":{"latitude":-34.021682824034,"longitude":18.4837339189645},"polygons":[{"coordinates":[[[-34.0224675816069,18.47607560705454],[-34.021900339603782,18.476424942466956],[-34.021834632851942,18.47667223294113],[-34.021763236949283,18.4766453367028],[-34.02119900085917,18.477001621671914],[-34.021216553524575,18.477231713278478],[-34.020956999043712,1

I have a table of addresses with these values in a single field, example: Main St/Carter Ave. I want to put Main St in a new field named StreetName, and Carter Ave in a new field named IntStreetName. I know there must be a method for parsing the values to the left and right of the "/" separator. How can I do this in FME? I know how to do this in python using split. I am new to FME.

The error i received is

What happens to automatic replies to FME Server sent emails (out of office, undeliverable, etc.)? Can Server be configured to route them somewhere useful?

Hi. I use a tester. It's with path extractor. The tester have a fonction to exclude some folder. I need to exclude all the folder with name include "0_".The floder containt path with "0_" are exclude.  I need help to have the right expression to select all the folder with "0_" in the path name. Thank 

Hello, Is there a transformer capable of merging adjacent faces? Ie. I have 4 adjacent faces (walls, roof) and I want to create a single object (building). Thanks!

Hi,I'm trying to create a scripted parameter to concatenate some of the FME Server Parameters, but all the FME Server Parameters come back as "None" in my scripted parameter, even though I've explicitly set them in FME Workbench.This is on MacOS FME Desktop 2022.1.2.0 (build 22627). I've tried using fme.macroValue, same result. I can use other user parameters in a scripted parameter. Is it not possible to use server parameters inside scripted parameters?

Hi, i failed to convert this format to an CSV with header Has anyone seen this type of structure before?Thanks for all{    "nbResults": "2",    "columnList": [        "THE_LIBELLE",        "THE_ACTIF",        "THE_DT_CREA",        "THE_UTIL_CREA",        "THE_DT_DERN_MAJ",        "THE_UTIL_DERN_MAJ",        "THE_ORDRE"    ],    "keyList": [        "THE_ID"    ],    "rowList": [        {            "columnDataList": [                "Commercial",                "1",                "11/10/2022 18:15",                "Test X",                "11/10/2022 18:15",                "Test Y",                "1"            ],            "keyDataList": [                "1"            ]        },        {            "columnDataList": [                "Culturelle",                "1",                "11/10/2022 18:15",                "Test X",                "11/10/2022 18:15",                "Test Y",                "2"            ],            "keyDataList": [                "2"            ]      

Hello,I know this is weird but somehow I cannot find the Google API key that I got but I do have it stored in the workbench file for years now, in the Geocoder transformer. Any idea how/if I could retrieve the API Key somehow? Many thanks

anyone tell me how can i get the data I m using HHTPcaller how can I get the Columns

I have a mix column that contains numbers and letters. in some records the first value or two first values ​​are number and then is a space then comes letter. the space und letter don't appear in all records. if a record contains this space I want to remove the space between number and letter.For example : 2 a -> 2a oder 22 a -> 22a.   

Via "Add or Remove programs" I select FME Desktop 2020.0 and click Uninstall. This message appears: "The feature you are trying to use is on a network resource that is unavailable. Click OK to try again, or enter an alternate path to a folder containing the installation package fme-desktop-2020.0.2-b20232-win-x64.msi in the box below." Unfortunately I can't find the installer anywhere, so I can't uninstall. Does anyone have any suggestions how I can uninstall FME 2020.0?

Hi!I have a problem with JSONUpdater and the function "Delete From Array". My case : I have this JSON fileI want to delete the value 79240 in "structure_ids". In JSONUpdate, I can't write the value, it doesn't work.I do write the position of this value. How can I do this dynamically? Is there an IndexOf function on FME?And when I write a position, here 4, in JSONUpdater, it removes 2 values ​​instead of one (79240,79389). Thank you for your help 

Hello,I need to do a simple operation in any GIS software, like QGIS, but I can't replay it in FME, and then load this data on ArcGIS Server. For example, I have two polygons with the same code (two rown in a data base) and I need to fusion them into a single one, using a common attribute, the code. The result would be two geometries and only one row into database.  If I use Aggregator transformer, checking group by this attribute, apparently the result is ok, but output a geometry collection don't load to ArcGIS Server. I tried to use GeometryCoercer, after the output port of Aggregator transformer, but it didn't work.  So, can someone help me? Thanks!

Using FME 2021.2. I keep having to go into workspaces writing to SDE and change Table Handling to Truncate Existing. I know I have done this repeatedly on some workspaces and then come back to find set to Create If Needed. Anyone else have this happen?

I realize the fanout option is probably the best option. I have not used FME in quite a while and am looking for someone to spoon feed this to me. I need to read in a single GDB and export to another GDB based on the "LAYER" field.  

Hey community!How can i export CSV output without attribute name? I am transforming a CSV file with East North coordinates but in output the first data is the name of the "_result" attribute that I would like to delete (attached image). Thank you!

Does one get any certification or acknowledgment letter, after finishing the FME training?

Hello,I have several thousand records, each with a date and demographic information. I have set up a workflow using the statistics calculator to get a cumulative sum of each demographic column. Where I am hung up though is grouping these records into weeks, and then doing my cumulative statistics for each week.Any help would be greatly appreciated!

The drawing has the title block "fugi tb info". When it's run, it says that autocad_block_name has no value.Help would be appreciated.

I am trying to create a simple dynamic workflow. But i struggle to understand how to add or remove feature types to the reader.For illustration i have created a database with 3 tables which are. I am reading them into my workbench using the "Single Merge Feature Type" option. The 3 tables can be seen under "Feature Types to Read"Immediately below it only the table1 listed under feature types. I am confused to why not all 3 tables are listed there?If i go to update the reader only table 1 is shown But if i run the workbench the dialog for Translation Parameter Values show all 3 tables I fail to see the logic behind this? How do I add or remove one feature type? Imagine I have 35 tables and I want to add or remove 1 of them from the reader. How do I do that?

Can we use FME Desktop for data migration from ArcFM Fiber to ArcFM enabled UNM?  Are there any workbenches similar to Electric/GAS/WATER available for Fiber Telecom ?

We currently have an Excel macro to copy cell data from an Excel source sheet and paste to another destination sheet. Once pasted, we will position those data in particular columns and apply some lookups.What would be the best approach to mimic such process in FME? Is it feasible to execute all those detailed steps by using FME transformer(s)?