JSON format

Is it possible to pull community builder fields in the database to an app in JSON format?
Thanks

You can make your own custom JSON API endpoint for CB using CB Auto Actions. Use a Code action with Method set to PHP, have your PHP return an array of whatever data you like, then under Output select JSON for its display. You should add some sort of security to this though using conditions (e.g. API Key check).

Could you point me in the right direction on how to set up (e.g. API Key check).

thanks

Below topic is an example of setting up a custom JSON API endpoint.

www.joomlapolis.com/forum/255-developer-members-support/243474-subscription-licence-key#322990

Can you please explain how to can generate the unique ids using the NEWID() SQL function in detail.
So when someone joins the unique Id is generated? For membership number.
The end point I would like would be
Name
User Name
membership/plan = active or inactive True or False
membership/plan expires?
membership Number ( the unique ids using the NEWID() SQL function )

Another thing How do I get the joomla Joomla! 3.9.24 websites API_KEY_HERE ? to set up a pull request?
Or how do I make Or where is the users API_KEY_HERE ?
Thanks

Can you please explain how to can generate the unique ids using the NEWID() SQL function in detail.

See the below MySQL documentation on how to use it's UUID() function to generate a unique ID.

dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_uuid

If I had a custom database table with the name _license_keys then I might have the below for example in a Query auto action.

Another thing How do I get the joomla Joomla! 3.9.24 websites API_KEY_HERE ? to set up a pull request?
Or how do I make Or where is the users API_KEY_HERE ?

You replace API_KEY_HERE with whatever you want. Ideally it should be something you generate something like a password that only you know.