Output mapping for SQL connector call
-
roberth.simplifier@mailbox.org’5 years ago #11897
Hi,
I have a hard time with the output mapping of my conenctor call.
I have a SQL database running in a VPS, created a SQL connector and a connector call.
The connector call itself is working which I can see with the test function. Also the call is working in my app because I can see the results of the call in chrome inspector.Anyway I’m not able to properly map the output to a table or even to a simple text field.
The result off the call “/” is of data type collection of a struct which has the same elements like my SQL query.
The output mapping is as follows:
https://share.mailbox.org/ajax/share/0e005da80255cd49e17def9255cd43a383696dbb1e52ed36/1/8/NjM/NjMvMTM5When i execute my app the table and the text will stay empty.
Furthermore I can not conenct the ID of type INT to the text field in the table. Why?What am I dooing wrong?
Thanks in advance and regards
RobertChris BouveretHas successfully completed the online course IntroductionHas successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)Has successfully completed the online course Advanced (320)Has successfully completed the Intermediate CertificationHas successfully completed the Advanced Certification5 years ago #11907::Hi Robert,
it seems that there is a problem with your output mapping. I looked at your freemium instance and recognized that there are no example Apps present. I just transported an example app (ITIZ_Template_SQL_ShoppingList) and connector to your instance so that you can compare and fix your issue. Hope that helps, if you have further questions please let us know
Best RegardsAttachments:
You must be logged in to view attached files.roberth.simplifier@mailbox.org’5 years ago #12082::Hi chris,
thanks for your reply and for transporting the example app again (I deleted it beforehand).
In my application I’m not able to connect the first bullet (which is “shoppingListItems (optional)” in your example). Regardless of the datatype I am using.
Maybe thats the reason my table stays empty.
I don’t undestand the mechanism which is behind this output mapping and what the first bullet represents (maybe each member of the collection, index in a arrays in classicle terms).Regards Robert
Chris BouveretHas successfully completed the online course IntroductionHas successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)Has successfully completed the online course Advanced (320)Has successfully completed the Intermediate CertificationHas successfully completed the Advanced Certificationroberth.simplifier@mailbox.org’5 years ago #12264::Thanks Chris,
it is working as expected now.
I always looked for the configuration of the data types and the mapping, but I never considered the configuration of the table widget itself.
Thanks very much.
This is a good starting point to get used to this kind SW development.Thank you evry much for you help.
Regards Robert
You must be logged in to reply to this topic.