Output mapping for SQL connector call

  • 6 years, 7 months 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
    Keymaster
      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
    6 years, 7 months 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.
    6 years, 7 months 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
    Keymaster
      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
    6 years, 7 months 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

    6 years, 7 months 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.