How to find all services that use JSON v1

Products

• CA API Gateway

Issue/Introduction

In order to update gateway to 11.2 need to first update JSON assertions used in policies to JSON v2 

Look for a tool to assist 

 

Environment

Gateway 11.1.1

Resolution

The attached files can be used to create a service when end point is accessed it queries the SSG DB and  report all service names that include the JSON v1 assertions 

Graphman file OR XML export of the service from policy manager

Graphman: When imported creates a new folder JSON-V1 for the new service JSON-v1 

graphman import --gateway <defined_gateway> --using install-bundle --input JSON-V1.json

OR

Policy Manager: Create a new service, then import the XML file

After creating the service, create a JDBC connection to the master SSG DB, connecting as a gateway user.  Then modify the new service to use the JDBC connection 

Then access the new-point to view report (NOTE: required to provide admin user and password) 

https://<gateway_host>::8443/json1

Example summary report:

Current results are being filtered against:

Service Name Containing JSON V1 assertion

OTK Fail Message to HTML

::l7.apim.system::Rate & Quota Policy Enforcement Fragment::2.0

::l7.apim.system::Rate & Quota Enforcement Policy Template::2.0

openid-client-register

openid-client-register-configuration

auth/oauth/v2/device-verification

auth/oauth/v2/authorize

.

.