API Portal: Identify APIs whose name is different from the name in the proxy

Products

• CA API Developer Portal
• CA API Gateway

Issue/Introduction

Is there a query that can be executed against the MySQL DB on the portal or gateway that will highlight which APIs have a difference between the name in API Portal and Gateway Service Policy name?

Environment

API Portal: 3.5

API Gateway 9.2

Resolution

For the portal, there is no query to view the APIs. The APIs are not stored in the lrs database. For the gateway, you can run the following query (it filters out unnecessary APIs such as OTK services that are not created by a user):

SELECT published_service.name from published_service JOIN policy ON HEX(published_service.policy_goid) = HEX(policy.goid) AND policy.xml NOT LIKE "%L7p:ApiPortalManagedServiceAssertion%" AND published_service.name NOT LIKE "%API Portal Integration Service%" AND published_service.name NOT LIKE "%protected%resource%"
AND published_service.name NOT LIKE "%auth/oauth%" AND published_service.name NOT LIKE "%jwks_uri%" AND published_service.name NOT LIKE "%openid%" AND published_service.name NOT LIKE "%connect/session%" AND published_service.name NOT LIKE "%oauth/%" AND published_service.name NOT LIKE "%/apidocs/%" AND published_service.name NOT LIKE "%portal/storage%" AND published_service.name NOT LIKE "%OAuth%" AND published_service.name NOT LIKE "%OpenID%" AND published_service.name NOT LIKE "%API Key Management Service%" AND published_service.name NOT LIKE "%API Portal%" AND published_service.name NOT LIKE "%LB_Health_Check%" AND published_service.name NOT LIKE "%Gateway REST Management Service%" AND published_service.name NOT LIKE "%Echo Service%";