Posts

Showing posts from August, 2024

Google Console API - Restart

 fetch('https://XXX-partner.saviyntcloud.com/ECM/savRoles/applicationrestart', {     method: 'POST',     headers: {         'Content-Type': 'application/x-www-form-urlencoded; charset=UTF-8',         'Authorization': 'Bearer YOUR_ACCESS_TOKEN',         'X-Requested-With': 'XMLHttpRequest'     },     body: new URLSearchParams({         'param1': 'value1',         'param2': 'value2' // Add your form data here     }) }) .then(response => response.text()) // Use .json() if the response is JSON .then(data => console.log(data)) .catch(error => console.error('Error:', error));

SQL - Get user password

select * from ( select username, password p from users where userkey in (select userkey from user_savroles where rolekey=1) )d  limit 10 

Labeling Tips

Image
  The following is a small offering based on experience of what might be called a Label Name to Campaign Certification table map which is useful for understanding which Label Name you need to use in User Interface Branding Configuration to impact a table column in a Campaign: Cert.<columnname>.label => User Manager User_<COLUMNNAME>.ATTESTATIONS => Entitlement Owner

EQ - Rename Security System

  SELECT  'Google' AS securitysystems__systemname , 'Google' AS securitysystems__displayname , systemkey as  securitysystems__PRIMARYKEY  FROM securitysystems  where systemkey=70 limit 1;  

EQ - Rename Endpoint

  SELECT  'Google' AS ENDPOINTS__endpointname , 'Google' AS ENDPOINTS__displayname , ep.endpointkey as  ENDPOINTS__PRIMARYKEY  FROM ENDPOINTS  ep where ep.endpointkey=51 limit 1;