I am using the HTTPCaller to interact with an API, for that I use the setting Multipart/ Form Data. This is the way another user got the Endpoint to work for them and I just always used it. This works pretty well, the API does what I want, the connection is stable, but there is one problem. Sometimes it takes a lot of time to configure the Multipart-part.
For some jobs I need to configure dozens of parameters, this leads to a lot of typing, proofreading, etc.
For this particular endpoint I don't just need to give parameters about the object I want to edit (some inspection), but also something like a table definition. The row (row_id) and the value, for each attribute of my dataset. Since this API endpoint doesn't like it when I send in null values as values, I need to run several configurations of the same HTTPCaller one that drops each variation of Null values in the dataset.
Now I was wondering if I could somehow build the whole statement about the rows and their values with something in FME and then send the whole unit to the endpoint. Something like the JSONtemplater. Then I could just set that workflow up once and reuse it for different data. The JSONtemplater didn't work work for me. But who knows, maybe because I configured the Json wrong. Everything this API returns to me is in JSONs, it would make sense if it accepted them also. I think I would already be helped if I could see what exactly the HTTPCaller sends to my endpoint.
I would really appreciate any help you can give me!