Have You experience with JSON Export Joocode joomla extension?
Nope.
Do You think is CB compatible?
No idea.
You can use a Code action to do this I suppose, but like I said you still will have to write code. The initial setup and usage would be as follows.
Global
Triggers: None
Type: Code
User: Automatic
Access: Everybody
Action
Method: PHP
Code:
header( 'Content-Type: application/json' );
return json_encode( $data );
Return: Echo
What $data you output is entirely up to you. There's no security to this endpoint so you may want to add a condition like the following.
[get_key] Equal To YOUR_SECRET_KEY_HERE
This ensures the URL must contain whatever key you want (e.g. f24sg56#$%sfd) or the action won't execute.
You can execute the action directly using its URL found under the Global tab as "Internal Action URL". For JSON usage you'll need to add &format=raw to the URL.