SELECT
WebhookCode,
Description,
BaseUrl,
Httpmethod,
PayloadType,
Headers,
User,
Password,
ApiKey,
Timeout,
HookPayloadSql
FROM def_webhook
WHERE ServiceCode = '{service_code}'
AND Active = 'Y'
ORDER BY WebhookCode
SELECT
Parameter,
ParameterBlock,
ParameterSubBlock,
ParameterSubSubBlock,
ParameterSubSubSubBlock,
ValueType,
Required,
DefaultValue,
PostType,
DisplayName,
Description,
Example
FROM def_webhook_parameters
WHERE WebhookCode = '{webhook_code}'
AND Package IN ('{package}', '{archetype}', 'core', 'adhoc')
ORDER BY Rank