API Connect

  • 1.  Manage Fields in IBM Developer portal

    IBM Select
    Posted Mon July 19, 2021 07:59 AM
    Hi everyone,

    I have added new fields such as file upload to the signup form in developer portal. my question is where can i find the data that is being saved on the signup screen. is there a database where we can query the data ?

    Best Regards,

    ------------------------------
    joe alAbiad
    ------------------------------


  • 2.  RE: Manage Fields in IBM Developer portal

    IBM Select
    Posted Tue July 20, 2021 02:15 AM
    Hi joe,

    Are the custom fields not visible on the user profile ("My account") in Developer Portal? If you need to see the data stored, then find out the db pod name on the Developer Portal node, use kubectl to get to bash and then use mysql commands to select the database/tables. The custom fields may be stored in tables named like "node__field_<field_name>". Look for tables named "user*" as well.

    regards

    ------------------------------
    Parveen Kumar
    ------------------------------



  • 3.  RE: Manage Fields in IBM Developer portal

    Posted Tue July 20, 2021 04:30 AM

    Absolutely, categorically do NOT attempt to connect to the database directly.
    Doing so violates your IBM Support agreement and would lead to your support agreement being terminated. And yes we can tell when you have done so when you raise a Support Case.

    The portal database is an internal component and it is NEVER allowed to connect to it directly.

    If you want to look at the data in it then you can do so via supported drupal database APIs in a custom module, but in this case you don't need to go that low level. The custom fields will be viewable from the UI, you don't need to go messing around in the database. If you want to export a report of all the data then just create a View (Structure->Views) and you can even export it as JSON/CSV whatever.

    The custom field data will also be sent to api manager as part of the 'metadata' array map that exists on users, applications, consumer orgs etc... So you can even retrieve the data using the public API Manager APIs.

    Do NOT connect to mysql. I really cannot stress that enough.



    ------------------------------
    Chris Dudley
    ------------------------------



  • 4.  RE: Manage Fields in IBM Developer portal

    Posted Tue July 20, 2021 09:30 AM
    Hello Joe,

    what version are you using ?
    Everything that happens in the developer portal is translated into REST API against the manager.
    The data that you are looking for are stored by the manager.
    There is a REST API available that you can use to get information.
    https://apic-api.apiconnect.ibmcloud.com/v10/#/documentation/introduction
    If it is about signup and getting information about a user, this is stored by default in a provided management UR.

    ------------------------------
    Pierre Richelle
    IBM Hybrid Cloud Integration Specialists
    IBM
    +32474681892
    ------------------------------