Support Forum

Hi Roel!

In case of HTTP errors (and 400 is an error), we currently do not set $MT_HTTPExecute_Result.
Why does your server return "bad request"?

Hi Roel!

In case you want to get the result as a string value, you will have to serialize it, i.e. "serialize( $MT_HTTPExecute_Result )".
If you want to access distinct elements, you can use e.g. "$MT_HTTPExecute_Result/json/element1".

Hi Roel!

Return codes >= 299 are handled as error.

Sorry everyone
I am new on this forum
I use filemaker, and I need to make a small application to get data from Filemaker Server with API REST
Inside filemaker script I setup CURL option variable like this:

-X POST
D $_response_headers
--header "Content-Type: application/json"
--header "Authorization: Basic cmVzdDpyZXN0" (this is the username and password "base 64 encoded")
-d @$_authentication_json (This is the variable that get Json result, in the case of altova I use $MT_HTTPExecute_Result variable

I use the RESTful API Request panel, use Basic/OAuth setup, where I write username and password
But I get error:

Error response:
{"messages":[{"message":"Invalid content type (application/x-www-form-urlencoded). These are valid: application/json","code":"1708"}],"response":{}}
Error executing REST POST request: FatalError: I/O operation on file 'https://cmstudio.eu/fmi/data/vLatest/databases/beezwax_data_api_demo_19/sessions' failed.
Details:
I/O Error 400: Bad Request

I don't know where to write the curl option and how to write in the parametr table inside RESTful API Request panel

Hi Mario!

It should be possible to achieve this with an "Execute REST Request" action. Please see the attached screenshot how to map your parameters. Since I don't know the JSON required by your server the request ends in an error. I hope the attached solution helps.

Thanks ELP
I change my way, I use Odata
No error, but also with your sample no error
I have a stupid question (I am 70 yeas old.... you understand..)
No error on the request result, I store the result on $MT_HTTPExecute_Result
But when I try to uodate node from $MT_HTTPExecute_Result give me error

This is the error
Starting Project Validation (C:\Users\mario\Documents\Altova\VenturiLocal\Odata.mtd) ...
Project Validation (C:\Users\mario\Documents\Altova\VenturiLocal\Odata.mtd) - 0 error(s), 0 warning(s)
Starting Simulation ...
Executed on server: Next page: MainPage
Executed on server: Load '$XML1' (Url: )
Execution Time: 0.00s
Data transferred from server to client: New page XML '$XML1'
Executed on server: Control Action of Button Button1:
Executing REST GET request
URL: https://cmstudio.eu/fmi/...OData_SampleData/PERSON?$select=ID,FirstName,LastName
Execution Time: 0.07s
Cannot Update Node '$PERSISTENT/Root/$XML1/JsonResult/Result' (no 'Target Node' found)
Simulation - 0 error(s), 1 warning(s)

Hi Mario!

I've modified your solution a little bit so you get your JSON result linked under the result element. Please note that the current solution will always link the result of the new request as last child under result. You might want to remove the previous results with the Delete Node(s) action first.