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/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 Introduction
            Has 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 Certification
            Has successfully completed the Advanced Certification
          5 years ago #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’
              5 years ago #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 Introduction
                  Has 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 Certification
                  Has successfully completed the Advanced Certification
                5 years ago #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’
                    5 years ago #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

                  Viewing 5 posts - 1 through 5 (of 5 total)

                  You must be logged in to reply to this topic.