Enabling REST API connection to M3 BE for a Report Manager installation

Perform this procedure if you are using REST APIs instead of MvxAPIs.

Open the active M3ReportManager database.
Locate the table a3M3ReportExtDataConnection and verify if the ExtDataConnectionName "M3RESTAPI" exists.

If the database record does not exist, run the SQL script.

Note: You must change the text within the brackets according to your own configuration before you execute the script.

INSERT [dbo].[a3M3ReportExtDataConnection] ([a3Id], [ExtDataConnectionName], [ExtDataConnectionType], [ExtDataConnectionUser], [ExtDataConnectionPwd], [ExtDataHost], 
[ExtDataPort], [ExtDataConnectionString], [ExtDataEntity], [tenantId], [timeOfUpdate], [timeOfCreation]) VALUES (N'57104D0C-1A46-4677-A492-4DE77BB7ACB3', N'M3RESTAPI', 
N'REST', N'[api user]', N'[api pwd]', N'https://[M3 BE server]:[ M3 BE REST port]/m3api-rest/', N'', N'', N'', NULL, CAST(0x0000A25301180B42 AS DateTime), CAST(0x0000A25301180B42 AS DateTime))

Enable REST API in the ReportManagerWCF website:
1. Open the IIS application settings.
2. Specify this information:
  
  M3APIRESTPath
  
  Specify the M3 API REST path:
  
  https://[M3 BE server]:[ M3 BE REST port]/m3api-rest/.
  
  M3APIType
  
  Select M3restAPI.
  
  certPath
  
  Specify the path and file name of the grid client certificate.
  
  certPassword
  
  Specify the password of the grid client certificate.
  
  M3BEAuthType
  
  Provide the generated certificate.
  Note: Default value is Certificate.
Enable M3 REST API in the ReportManagerH5 website:
1. Open the IIS application settings.
2. In M3APIType, select M3restAPI.
Open the AAP_Connectors.xml file which is located under the ProgramData\accure\AAP\Resources folder of the Report Mananger server, for example, C:\ProgramData\accure\AAP\Resources

Specify the property node for both M3 connector and M3_API connector:


Property	Description
<restpath>	Specify https://`[M3 BE server]`:`[M3 BE REST port]`/m3api-rest/.
<certPath>	Specify the path and file name of the grid client certificate.
<certPassword>	Specify the password of the grid client certificate.
<user>	Specify the BE user for M3 and M3_API connectors.
<password>	Specify the BE password for M3 and M3_API connectors. Note: These login credentials are required for BE API.