Skip to main content
  • EN

I’m trying to use the FeatureReader to read 3 features from an ArcGIS portal feature service layer by reading in a spreadsheet and using a WHERE clause with an attribute in the spreadsheet. 

The FeatureReader will connect to the service and I can select the correct table in the “Feature Types to Read” parameter. But when I try to add the WHERE clause FME crashes before I can start creating the WHERE clause. The second image below indicated the point when it crashes.

I can read the full table with no problem using the ArcGIS Portal Feature Service reader.

 

How can I get the FeatureReader to run and read the required features?

 

 

I see the same behaviour if i try and open the Database Tables in the clause builder. I can copy and paste the where clause directly however.

This is not a solution but a work around seems to be to leave the “FeatureTypes to Read” empty and manually enter the WHERE clause. The Feature Reader is then created with an output for each Feature Type and the correct features are read.  Its just the where clause builder that causes the problem.

 

Reply


Community Stats

30,351
Posts
115,341
Replies
38,081
Members
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.