Hi @kristianbj,

Could you provide a bit more details so we can best help you? What type of database (Microsoft SQL Server, Oracle, Postgres, etc.) are you working with? And to set the Request URL parameter in the HTTPCaller, are you looking to access data via ArcGIS REST API/ArcGIS Online feature services, or are you looking to create web services in other ways? Thank you!

Hi @alyssaatsafe

Im writing to MSSQL Server. Im trying to use http calls like this one:

$(WMX_url)/@Value(jobid)/extendedProperties/@Value(tableName)/@Value(recordId)/update

With the following private parameters:

And using post method to populate fields in the database:

So now im looking for a http call, that makes an update in a field of a feature based on a ID match with a new incoming feature, that has a reference to this old feature in a column "reference_messageID".

My own idea was first to use a tester to find all incoming features that have value in column "References Type", becomes if they have a value there they need to affect an older feature. Then I thought of looping through the existing data in the database (preferably using a HttpCaller transformer) to find match with ID from old feature being equal to value in column reference_messageID in new/incoming feature. If it finds a match between these two (oldfeature.ID=newfeature.referencemessageID) then it should populate a field in the old feature "References" with the ID value from the new feature + the type written in column "References Type" being either 'Update' or 'Delete' for an example.

But I cannot really make it work, and Im not that experienced with looping in FME.

Thanks so much for your time.

Hi @kristianbj, thank you for providing the screenshots and explanation.

Is the http request in your example able to update individual records in the database based on recordId? I created a simplified example based on the process you described, and the actual parameter settings in the HTTPCaller may need adjustments depending on how the http request was set up to update the database. I have also attached the workspace here.

So I created a JSON file called feature1, with properties Reference type and Reference MessageID and a database table called feature2 with fields ID and References. In the workspace, first read feature1.json with JSON reader, followed by a Tester to test Reference type with “Attribute Has a Value”. Then connected the Passed port from the Tester to the HTTPCaller, where I had an HTTP request that would update the record matching to References MessageID, and update the References field with values specified in the Upload Body in the HTTPCaller. As the workspace processes data feature by feature, it would work as if it is looping. Each References MessageID would trigger one individual http request.

Hope this helps a bit. Just out of curiosity, is there a particular reason you prefer using HTTPCaller to update the database, instead of using SQL with SQLExecutor for example? :)