[roberth.simplifier@mailbox.org’]

vor 5 Jahren #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/NjMvMTM5

When 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
Robert

[Chris Bouveret Has 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 Certification]

vor 5 Jahren #11907

Up

0

Down

::

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 Regards

Attachments:

You must be logged in to view attached files.

[roberth.simplifier@mailbox.org’]

vor 5 Jahren #12082

Up

0

Down

::

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 Bouveret Has 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 Certification]

vor 5 Jahren #12141

Up

0

Down

::

Hi Robert,

i fixed the issue within your app directly. Within the Table Widget you selected the wrong collection. Your App works as expected now. Please have a look and let me know.
Best
Chris

[roberth.simplifier@mailbox.org’]

vor 5 Jahren #12264

Up

0

Down

::

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