Hi Ingo,
Maybe the import mapping doesn't match the JSON result?
You could compare the JSON snippet from the import mapping with your result…
Issues might be in cardinality e.g you expect an array, but the result is only one element, but also the datatypes could have a mismatch...all kinds of errors possible.
Furthermore you can set your loglevels to debug for the JSON import.
Lastly you could post a little more info to this question, so we can better understand :-)
Go make it!
Jacob
Probably the mapping is wrong. Set the response handling option to “store in a string” and after the rest-call in an import-JSON-activity feed that string to your JSON-mapping and see what happens. Likely you will see the same result but easier to understand and test and tweak until the mapping is right.
Helpful is to create a new JSON_Structure and paste the value of the string into it. This will show you if the received JSON is a valid one.
Did you create a JSON structure from the response that is stored in the string, and then use the JSON structure to create your import mapping? Here’s a link to some information that may be helpful.https://docs.mendix.com/howto/integration/consume-a-rest-service
I tried my best, but I didn’t make after my vacation. The JSON contains an array. I am created a JSON structure in mendix and copied the reply from the http request function. After that I am created import mapping object, but it looks a little bit different than the example. The root entity is completely empty! And I have modified the requesting microflow and used for the conversion an import mapping block. And it didn’t work… I think the mapping function is not configured correctly, but I can’t find the error. Do you have a hint for me?
Thanks
Between the “Call REST (GET)” and the “Import from JSO” do a “Retrieve JsonObject_Root” over association from NewGridData and feed that result to the Importmapping.
Thanks Tim, will change the microflow later and test it. When I am arrive in the office.
@tim
I tried your workaround and add a retrieve activity to the microflow. But I can’t select the NewGridData object, it’s not listed in the dialog. And I am calling the microflow by a simple button without any parameters. The picture shows my availabe options:
Sorry for the many questions on this topic, I am still working my way into the Mendix development environment.
I managed it. But now I have some new questions… I will create a new topic.
Thanks