OpenIDM | Mirror of https://stash.forgerock.org/projects/OPENIDM/repos/openidm
 by  OpenRock Java Updated: 2 years ago - 4.0.0 License: No License
Download this library from
Build Applications
kandi X-RAY | OpenIDM REVIEW AND RATINGS
Mirror of https://stash.forgerock.org/projects/OPENIDM/repos/openidm
- OpenIDM has a low active ecosystem.
- It has 25 star(s) with 23 fork(s).
- It had no major release in the last 12 months.
- It has a neutral sentiment in the developer community.
- OpenIDM has no issues reported.
- OpenIDM has 3 vulnerability issues reported (0 critical, 0 high, 3 medium, 0 low).
- OpenIDM does not have a standard license declared.
- Check the repository for any license declaration and review the terms closely.
- Without a license, all rights are reserved, and you cannot use the library in your applications.
- OpenIDM releases are available to install and integrate.
- Build file is available. You can build the component from source.
Top functions reviewed by kandi - BETA
kandi has reviewed OpenIDM and discovered the below as its top functions. This is intended to give you an instant insight into OpenIDM implemented functionality, and help decide if they suit your requirements.
- Sets the attributes .
- Wraps an internal connection factory .
- Synchronize the given stage .
- Performs aon operation .
- Generate class .
- Get orientation configuration .
- Execute a collection of relationships
- Get the linked resources
- Removes all relationships from the resource
- Handle a query .
OpenIDM Key Features
Mirror of https://stash.forgerock.org/projects/OPENIDM/repos/openidm
OpenIDM examples and code snippets
- Decode encoded string while transforming in openidm
- Mysql output from double row to a single raw grouped by a key
- Using wildcards with SET
- MySQL: json extract remove quotes
- CASE WHEN with COLLECT_SET
- C#: Json to Object: Getting error ex = {"Unexpected character encountered while parsing value: {. Path 'result', line 1, position 12."}
- Rest Sharp Patch Request
- How to test OpenIm (ForgeRock) Request on Postman?
- Ajax Header Request "X-openIDM-Reauth-Password" not working
- How to Implement function return from http request
Decode encoded string while transforming in openidm
if (source != null)
{
var base64 = Packages.org.forgerock.util.encode.Base64url
b64tO = new Packages.java.lang.String(base64.decode(source));
logger.info("Decoded: {}", b64tO);
target = b64tO;
}
if (source != null)
{
var base64 = Packages.org.forgerock.util.encode.Base64url
b64tO = new Packages.java.lang.String(base64.decode(source));
logger.info("Decoded: {}", b64tO);
target = b64tO;
}
Mysql output from double row to a single raw grouped by a key
select max(case when propkey='/CRSMID' then propvalue end) CRSMID,
max(case when propkey='/partyID' then propvalue end) partyID
from openidm.managedobjectproperties
where key in (
select key
from openidm.managedobjectproperties
where propvalue in ('97539510','97939103'))
and propkey in ('/CRSMID','/partyID') group by key
select max(case when propkey='/CRSMID' then propvalue end) CRSMID,
max(case when propkey='/partyID' then propvalue end) partyID
from openidm.managedobjectproperties
where key in (
select key
from openidm.managedobjectproperties
where propvalue in ('97539510','97939103'))
and propkey in ('/CRSMID','/partyID') group by key
Using wildcards with SET
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT @searchInput
-----------------------
DECLARE @searchInput varchar(50)
-----------------------
DECLARE @searchInput varchar(10)
SET @searchInput = 'dm'
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT @searchInput
DECLARE @searchInput varchar(50)
DECLARE @searchInput varchar(10)
SET @searchInput = 'dm'
MySQL: json extract remove quotes
select objectid,
TRIM(BOTH '"' FROM
(JSON_EXTRACT(fullobject, '$'))
) as mail
from openidm.managedobjects
where objecttypes_id=5
and (JSON_EXTRACT(fullobject, '$.mail'))='fake@email.com';
select objectid,
TRIM(BOTH '"' FROM
(JSON_EXTRACT(fullobject, '$'))
) as mail
from openidm.managedobjects
where objecttypes_id=5
and (JSON_EXTRACT(fullobject, '$.mail'))='fake@email.com';
CASE WHEN with COLLECT_SET
SELECT id, max(CASE WHEN productname='OpenDJ' THEN 1 ELSE 0 END) AS flag
FROM ds.forgerock
GROUP BY id;
SELECT id, max(CASE WHEN productname='OpenDJ' THEN 1 ELSE 0 END) AS flag
FROM ds.forgerock
GROUP BY id;
C#: Json to Object: Getting error ex = {"Unexpected character encountered while parsing value: {. Path 'result', line 1, position 12."}
public class Rootobject
{
public Result[] result { get; set; }
public int resultCount { get; set; }
public object pagedResultsCookie { get; set; }
public string totalPagedResultsPolicy { get; set; }
public int totalPagedResults { get; set; }
public int remainingPagedResults { get; set; }
}
public class Result
{
public string _id { get; set; }
public string _rev { get; set; }
public string[] ahaMemberGroup { get; set; }
}
public class Rootobject
{
public Result[] result { get; set; }
public int resultCount { get; set; }
public object pagedResultsCookie { get; set; }
public string totalPagedResultsPolicy { get; set; }
public int totalPagedResults { get; set; }
public int remainingPagedResults { get; set; }
}
public class Result
{
public string _id { get; set; }
public string _rev { get; set; }
public string[] ahaMemberGroup { get; set; }
}
Rest Sharp Patch Request
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
-----------------------
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
-----------------------
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
-----------------------
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
-----------------------
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
How to test OpenIm (ForgeRock) Request on Postman?
X-OpenIDM-Username
X-OpenIDM-Password
X-OpenIDM-Username
X-OpenIDM-Password
Ajax Header Request "X-openIDM-Reauth-Password" not working
{
"classPathURLs" : [ ],
"systemProperties" : { },
"requestAttributes" : { },
"scriptExtensions" : { },
"initParams" : {
"allowedOrigins" : "*",
"allowedMethods" : "GET,POST,PUT,DELETE,PATCH",
"allowedHeaders" : "accept,x-openidm-password,x-openidm-nosession,x-openidm-username,content-type,origin,X-OpenIDM-Reauth-Password,x-requested-with",
"allowCredentials" : "true",
"chainPreflight" : "false"
},
"urlPatterns" : [
"/*"
],
"filterClass" : "org.eclipse.jetty.servlets.CrossOriginFilter"
}
{
"classPathURLs" : [ ],
"systemProperties" : { },
"requestAttributes" : { },
"scriptExtensions" : { },
"initParams" : {
"allowedOrigins" : "*",
"allowedMethods" : "GET,POST,PUT,DELETE,PATCH",
"allowedHeaders" : "accept,x-openidm-password,x-openidm-nosession,x-openidm-username,content-type,origin,X-OpenIDM-Reauth-Password,x-requested-with",
"allowCredentials" : "true",
"chainPreflight" : "false"
},
"urlPatterns" : [
"/*"
],
"filterClass" : "org.eclipse.jetty.servlets.CrossOriginFilter"
}
How to Implement function return from http request
policyFunction = eval("(" + validations.policyFunction + ")");
failures = policyFunction.call({ failedPolicyRequirements: [] },
fullObject,
value,
params,
propertyName);
policyFunction = eval("(" + validations.policyFunction + ")");
failures = policyFunction.call({ failedPolicyRequirements: [] },
fullObject,
value,
params,
propertyName);
COMMUNITY DISCUSSIONS
Top Trending Discussions on OpenIDM
- Decode encoded string while transforming in openidm
- Mysql output from double row to a single raw grouped by a key
- Using wildcards with SET
- How to implement a openidm splunk audit failover
- MySQL: json extract remove quotes
- CASE WHEN with COLLECT_SET
- C#: Json to Object: Getting error ex = {"Unexpected character encountered while parsing value: {. Path 'result', line 1, position 12."}
- Rest Sharp Patch Request
- How to test OpenIm (ForgeRock) Request on Postman?
- Ajax Header Request "X-openIDM-Reauth-Password" not working
Top Trending Discussions on OpenIDM
QUESTION
Decode encoded string while transforming in openidm
Asked 2020-May-27 at 21:46I want to decode the string while transforming the data from Active Directory to OpenIDM. Sync between the system is alright but one of the attribute have base64 encoded string.
I want to transform the property before persisting it into managed user object.
Anyone have any idea how can I achieve it. I tried few javascript ways but no success.
I want to decode the string while transforming the data from Active Directory to OpenIDM. Sync between the system is alright but one of the attribute have base64 encoded string.
I want to transform the property before persisting it into managed user object.
Anyone have any idea how can I achieve it. I tried few javascript ways but no success.
ANSWER
Answered 2020-May-27 at 21:46Finally I was able to achieve the decoding of the string using below transformation
if (source != null)
{
var base64 = Packages.org.forgerock.util.encode.Base64url
b64tO = new Packages.java.lang.String(base64.decode(source));
logger.info("Decoded: {}", b64tO);
target = b64tO;
}
Hope it help someone !!!
QUESTION
Mysql output from double row to a single raw grouped by a key
Asked 2019-Jul-03 at 10:25I have this query:
select key, propkey, propvalue
from openidm.managedobjectproperties
where key in (
select key
from openidm.managedobjectproperties
where propvalue in ('97539510','97939103'))
and propkey in ('/CRSMID','/partyID');
which basically returns this output:
key | propkey | propvalue
------------------------------
1482195 | /CRSMID | 814427
1482195 | /partyID | 97539510
1488492 | /CRSMID | 1415615
1488492 | /partyID | 97939103
For each key - which is the same - I would like to output a two column table with the propvalues (first column the /CRSMID, and second column the /partyID) in this way:
CRSMID | partyID
-------------------
814427 | 97539510
1415615 | 97939103
but I'm not sure on this since the group by key is not working.
I have this query:
select key, propkey, propvalue
from openidm.managedobjectproperties
where key in (
select key
from openidm.managedobjectproperties
where propvalue in ('97539510','97939103'))
and propkey in ('/CRSMID','/partyID');
which basically returns this output:
key | propkey | propvalue
------------------------------
1482195 | /CRSMID | 814427
1482195 | /partyID | 97539510
1488492 | /CRSMID | 1415615
1488492 | /partyID | 97939103
For each key - which is the same - I would like to output a two column table with the propvalues (first column the /CRSMID, and second column the /partyID) in this way:
CRSMID | partyID
-------------------
814427 | 97539510
1415615 | 97939103
but I'm not sure on this since the group by key is not working.
ANSWER
Answered 2019-Jul-03 at 10:25use conditional aggregation
select max(case when propkey='/CRSMID' then propvalue end) CRSMID,
max(case when propkey='/partyID' then propvalue end) partyID
from openidm.managedobjectproperties
where key in (
select key
from openidm.managedobjectproperties
where propvalue in ('97539510','97939103'))
and propkey in ('/CRSMID','/partyID') group by key
QUESTION
Using wildcards with SET
Asked 2018-Sep-21 at 10:02Table
productName description
+++++++++++++++++++++++++
OpenIDM Platform for building enterprise provisioning solutions
OpenDM Full-featured access management
OpenDJ Robust LDAP server for Java
In the above table when I run below query I get the first two records as expected
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT * FROM ForgeRock
WHERE productName like '%DM%'
Result
OpenIDM Platform for building enterprise provisioning solutions
OpenDM Full-featured access management
But when I run the below query, pattern matching doesn't seem to work properly and I get all the records.
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT * FROM ForgeRock
WHERE productName like '%'+@searchInput+'%'
Table
productName description
+++++++++++++++++++++++++
OpenIDM Platform for building enterprise provisioning solutions
OpenDM Full-featured access management
OpenDJ Robust LDAP server for Java
In the above table when I run below query I get the first two records as expected
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT * FROM ForgeRock
WHERE productName like '%DM%'
Result OpenIDM Platform for building enterprise provisioning solutions OpenDM Full-featured access management
But when I run the below query, pattern matching doesn't seem to work properly and I get all the records.
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT * FROM ForgeRock
WHERE productName like '%'+@searchInput+'%'
ANSWER
Answered 2018-Sep-21 at 09:04You didn't declare the size of the varchar string. It default to 1. Do a SELECT on the @searchInput and see for yourself
DECLARE @searchInput varchar
SET @searchInput = 'dm'
SELECT @searchInput
QUESTION
How to implement a openidm splunk audit failover
Asked 2018-Aug-01 at 13:49i am using Splunk as the AuditHandler for my openIDM solution and I want to make sure that when the connection to Splunk fails for exp. in a server issue.
Then i want to rewrite the data since to timestamp of the connection loss.
Is there a simple solution for that or do i need to implement a logic?
thanks
Burhan
i am using Splunk as the AuditHandler for my openIDM solution and I want to make sure that when the connection to Splunk fails for exp. in a server issue. Then i want to rewrite the data since to timestamp of the connection loss.
Is there a simple solution for that or do i need to implement a logic?
thanks Burhan
ANSWER
Answered 2018-Aug-01 at 13:49If you can, write your openIDM events to a file and monitor that file with a Splunk Universal Forwarder (UF). The UF will read the file and send the contents to Splunk. If the connection to Splunk is lost, the UF will resume where it left off once the connection is restored.
QUESTION
MySQL: json extract remove quotes
Asked 2018-May-16 at 13:54I'm using MySQL 5.7.12 and this is my query.
select objectid, (JSON_EXTRACT(fullobject, '$.mail')) as mail from openidm.managedobjects where objecttypes_id=5 and (JSON_EXTRACT(fullobject, '$.mail'))='fake@email.com';
And this is the output
--------------------------------------------------
| objectid | mail |
--------------------------------------------------
| 001f73d9-f3d | "fake@email.com" |
--------------------------------------------------
I would like to remove the quotes from the output but since I'm using 5.7.12 I can't do it with JSON_UNQUOTE().
I tryed with REPLACE():
select objectid, REPLACE((JSON_EXTRACT(fullobject, '$.mail')), '\"', '') as mail from openidm.managedobjects where objecttypes_id=5 and (JSON_EXTRACT(fullobject, '$.mail'))='fake@email.com';
but the output is totally unrelated:
----------------------------------------------------------------------------
| objectid | mail |
----------------------------------------------------------------------------
| 001f73d9-f3d | 6C75632E6170617369383840676D61696C2E636F6D |
----------------------------------------------------------------------------
EDIT
This is my show create table openidm.managedobjects;
CREATE TABLE `managedobjects` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`objecttypes_id` bigint(20) unsigned NOT NULL,
`objectid` varchar(255) COLLATE utf8_bin NOT NULL,
`rev` varchar(38) COLLATE utf8_bin NOT NULL,
`fullobject` mediumtext COLLATE utf8_bin,
PRIMARY KEY (`id`),
UNIQUE KEY `idx-managedobjects_object` (`objecttypes_id`,`objectid`),
KEY `fk_managedobjects_objectypes` (`objecttypes_id`),
CONSTRAINT `fk_managedobjects_objectypes` FOREIGN KEY (`objecttypes_id`) REFERENCES `objecttypes` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=445311 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
This is the fullobject json:
{"telephoneNumber":"077777777","mail":"fake@email.com","msisdnVerified":"true","countryCode":"+44","opCoProfileId":"MSISDN","opCo":"3UK","userName":"077777777","partyID":"777777777","accountStatus":"active","creationDate":"Wed Jan 24 2018 11:33:02 GMT+0100 (CET)","_id":"001f73d9-f3d","_rev":"3","global_id":"001f73d9-f3d","CRSMID":"50000048","migrated":"false","mailVerified":"true","mailVerifiedDate":"Wed Jan 24 2018 11:33:03 GMT+0100 (CET)","dateOfBirth":"1988-02-02","password":{"$crypto":{"type":"x-simple-encryption","value":{"cipher":"AES/CBC/PKCS5Padding","salt":"1P3TMv71pASuLkyVLFNnEA==","data":"iyj/h0fMU6aiTTBLL/Bb2w==","iv":"gQ6a5cAJYrtek5vcX8+mfw==","key":"openidm-sym-default","mac":"ntv0yTBDzCb0n8kvW4UklQ=="}}}}
I'm using MySQL 5.7.12 and this is my query.
select objectid, (JSON_EXTRACT(fullobject, '$.mail')) as mail from openidm.managedobjects where objecttypes_id=5 and (JSON_EXTRACT(fullobject, '$.mail'))='fake@email.com';
And this is the output
--------------------------------------------------
| objectid | mail |
--------------------------------------------------
| 001f73d9-f3d | "fake@email.com" |
--------------------------------------------------
I would like to remove the quotes from the output but since I'm using 5.7.12 I can't do it with JSON_UNQUOTE().
I tryed with REPLACE():
select objectid, REPLACE((JSON_EXTRACT(fullobject, '$.mail')), '\"', '') as mail from openidm.managedobjects where objecttypes_id=5 and (JSON_EXTRACT(fullobject, '$.mail'))='fake@email.com';
but the output is totally unrelated:
----------------------------------------------------------------------------
| objectid | mail |
----------------------------------------------------------------------------
| 001f73d9-f3d | 6C75632E6170617369383840676D61696C2E636F6D |
----------------------------------------------------------------------------
EDIT
This is my show create table openidm.managedobjects;
CREATE TABLE `managedobjects` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`objecttypes_id` bigint(20) unsigned NOT NULL,
`objectid` varchar(255) COLLATE utf8_bin NOT NULL,
`rev` varchar(38) COLLATE utf8_bin NOT NULL,
`fullobject` mediumtext COLLATE utf8_bin,
PRIMARY KEY (`id`),
UNIQUE KEY `idx-managedobjects_object` (`objecttypes_id`,`objectid`),
KEY `fk_managedobjects_objectypes` (`objecttypes_id`),
CONSTRAINT `fk_managedobjects_objectypes` FOREIGN KEY (`objecttypes_id`) REFERENCES `objecttypes` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=445311 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
This is the fullobject json:
{"telephoneNumber":"077777777","mail":"fake@email.com","msisdnVerified":"true","countryCode":"+44","opCoProfileId":"MSISDN","opCo":"3UK","userName":"077777777","partyID":"777777777","accountStatus":"active","creationDate":"Wed Jan 24 2018 11:33:02 GMT+0100 (CET)","_id":"001f73d9-f3d","_rev":"3","global_id":"001f73d9-f3d","CRSMID":"50000048","migrated":"false","mailVerified":"true","mailVerifiedDate":"Wed Jan 24 2018 11:33:03 GMT+0100 (CET)","dateOfBirth":"1988-02-02","password":{"$crypto":{"type":"x-simple-encryption","value":{"cipher":"AES/CBC/PKCS5Padding","salt":"1P3TMv71pASuLkyVLFNnEA==","data":"iyj/h0fMU6aiTTBLL/Bb2w==","iv":"gQ6a5cAJYrtek5vcX8+mfw==","key":"openidm-sym-default","mac":"ntv0yTBDzCb0n8kvW4UklQ=="}}}}
ANSWER
Answered 2018-Jan-24 at 11:57QUESTION
CASE WHEN with COLLECT_SET
Asked 2018-Feb-15 at 18:49I have a toy table:
hive> SELECT * FROM ds.forgerock;
OK
forgerock.id forgerock.productname forgerock.description
1 OpenIDM Platform for building enterprise provisioning solutions
2 OpenAM Full-featured access management
3 OpenDJ Robust LDAP server for Java
4 OpenDJ desc2
4 OpenDJ desc2
Time taken: 0.083 seconds, Fetched: 5 row(s)
I am trying to get a table like:
id flag
1 0
2 0
3 1
4 1
I am using the toy table to iterate and develop working code.
SELECT id, CASE WHEN "OpenDJ" IN COLLECT_SET(productname) THEN 1 ELSE 0 END AS flag,
GROUP BY id FROM ds.forgerock;
Note that in the toy data set, every id only has one distinct value, so COLLECT_SET doesn't seem necessary. However, given the actual data set actually has more than one distinct value, what I am trying to do will make more sense.
I have a toy table:
hive> SELECT * FROM ds.forgerock;
OK
forgerock.id forgerock.productname forgerock.description
1 OpenIDM Platform for building enterprise provisioning solutions
2 OpenAM Full-featured access management
3 OpenDJ Robust LDAP server for Java
4 OpenDJ desc2
4 OpenDJ desc2
Time taken: 0.083 seconds, Fetched: 5 row(s)
I am trying to get a table like:
id flag
1 0
2 0
3 1
4 1
I am using the toy table to iterate and develop working code.
SELECT id, CASE WHEN "OpenDJ" IN COLLECT_SET(productname) THEN 1 ELSE 0 END AS flag,
GROUP BY id FROM ds.forgerock;
Note that in the toy data set, every id only has one distinct value, so COLLECT_SET doesn't seem necessary. However, given the actual data set actually has more than one distinct value, what I am trying to do will make more sense.
ANSWER
Answered 2018-Feb-15 at 18:49Use max() for flag aggregation by id:
SELECT id, max(CASE WHEN productname='OpenDJ' THEN 1 ELSE 0 END) AS flag
FROM ds.forgerock
GROUP BY id;
QUESTION
C#: Json to Object: Getting error ex = {"Unexpected character encountered while parsing value: {. Path 'result', line 1, position 12."}
Asked 2017-Nov-06 at 21:04I'm not sure if I setup my class wrong or not causing the error. I'm pretty new to working with Json.
Function code:
Response = OpenIDM.GetUserInformation(email, fields);
LDAPMembership = JsonConvert.DeserializeObject<LDAPMembership>(Response);
string id = LDAPMembership._id;
class:
public class LDAPMembership
{
public string[] result { get; set; }
public string _id { get; set; }
public string _rev { get; set; }
public string[] ahaMemberGroup { get; set; }
public string[] ahaDrupalPermissions { get; set; }
public string resultCount { get; set; }
public string pagedResultsCookie { get; set; }
public string totalPagedResultsPolicy { get; set; }
public string totalPagedResults { get; set; }
public string remainingPagedResults { get; set; }
}
Json String:
{\"result\":[{\"_id\":\"98d0d0b9-9506-40b4-84c4-e005d4bc25ec\",\"_rev\":\"1\",\"ahaMemberGroup\":[\"AONE\",\"AHA\"]}],\"resultCount\":1,\"pagedResultsCookie\":null,\"totalPagedResultsPolicy\":\"NONE\",\"totalPagedResults\":-1,\"remainingPagedResults\":-1}
Exception being thrown:
Unexpected character encountered while parsing value: {. Path 'result', line 1, position 12."}
I suspect I did not setup "result" correctly in my class. I searched around and found a similar issue and tried the response but that did not work.
Error gets thrown on this line:
LDAPMembership = JsonConvert.DeserializeObject<LDAPMembership>(Response);
I'm not sure if I setup my class wrong or not causing the error. I'm pretty new to working with Json.
Function code:
Response = OpenIDM.GetUserInformation(email, fields);
LDAPMembership = JsonConvert.DeserializeObject<LDAPMembership>(Response);
string id = LDAPMembership._id;
class:
public class LDAPMembership
{
public string[] result { get; set; }
public string _id { get; set; }
public string _rev { get; set; }
public string[] ahaMemberGroup { get; set; }
public string[] ahaDrupalPermissions { get; set; }
public string resultCount { get; set; }
public string pagedResultsCookie { get; set; }
public string totalPagedResultsPolicy { get; set; }
public string totalPagedResults { get; set; }
public string remainingPagedResults { get; set; }
}
Json String:
{\"result\":[{\"_id\":\"98d0d0b9-9506-40b4-84c4-e005d4bc25ec\",\"_rev\":\"1\",\"ahaMemberGroup\":[\"AONE\",\"AHA\"]}],\"resultCount\":1,\"pagedResultsCookie\":null,\"totalPagedResultsPolicy\":\"NONE\",\"totalPagedResults\":-1,\"remainingPagedResults\":-1}
Exception being thrown: Unexpected character encountered while parsing value: {. Path 'result', line 1, position 12."}
I suspect I did not setup "result" correctly in my class. I searched around and found a similar issue and tried the response but that did not work.
Error gets thrown on this line:
LDAPMembership = JsonConvert.DeserializeObject<LDAPMembership>(Response);
ANSWER
Answered 2017-Nov-06 at 21:04Visual Studio can do this for you. Get the clean JSON (without all those \"), put that Json on your clipboard, place your cursor in a C# file and select
Edit, Paste Special, Classes from JSon
public class Rootobject
{
public Result[] result { get; set; }
public int resultCount { get; set; }
public object pagedResultsCookie { get; set; }
public string totalPagedResultsPolicy { get; set; }
public int totalPagedResults { get; set; }
public int remainingPagedResults { get; set; }
}
public class Result
{
public string _id { get; set; }
public string _rev { get; set; }
public string[] ahaMemberGroup { get; set; }
}
Use as-is or clean up a little. Change Rootobject to whatever you like.
Note that you'd probaly want to fix the type of pagedResultsCookie .
QUESTION
Rest Sharp Patch Request
Asked 2017-Oct-24 at 14:20I'm very new still to Rest Sharp and Postman but I'm trying to make a "Update" to an existing user. Here is my code but I know its wrong. Does anyone have samples on how to perform a "replace" operation in Rest Sharp?
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + obj.userName.ToString();
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate();
//if (Update != null)
//{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
//request.AddParameter("application/json", "[\n {\n \"operation\": \"replace\",\n \"field\": \"/userName\",\n \"value\": \"testuser4@aha.org\"\n },\n {\n \"operation\": \"replace\",\n \"field\": \"/mail\",\n \"value\": \"testuser4@aha.org\"\n }\n]", ParameterType.RequestBody);
request.AddBody({ "operation": "replace", "field": "/userName", "value": "testuser4@aha.org"}, { "operation": "replace", "field": "/mail", "value": "testuser4@aha.org"});
IRestResponse response = client.Execute(request);
Postman says it should be something like this:
[
{
"operation": "replace",
"field": "/userName",
"value": "testuser4@aha.org"
},
{
"operation": "replace",
"field": "/mail",
"value": "testuser4@aha.org"
}
]
I would prefer to write it that way but I have no idea how. The other code suggested I make a string. I can write it out via string but Id prefer to write it out in the body if I can or possible. Thanks in advance
Edit:
Here is my class:
public class IdentityDetails
{
//public const string type = "user";
//public const string realm = "dc=aha,dc=org";
public string userName { get; set; }
public string mail { get; set; }
public string givenName { get; set; }
public string sn { get; set; }
public string accountStatus { get; set; }
public string avectraId { get; set; }
public string AHApw { get; set; }
public string password { get; set; }
public string ahaBirthYear { get; set; }
public string city { get; set; }
public string ahaGender { get; set; }
public string ahaJobTitle { get; set; }
public string ahaLeadScore { get; set; }
public string stateProvince { get; set; }
public string orgId { get; set; }
public string[] ahaMemberGroup { get; set; }
public string[] ahaMemberType { get; set; }
public string regMethod { get; set; }
//public string[] ahaDrupalPermission { get; set; }
}
I think what I need to do though as well will be pass in the current field and value, and pass in the new value for the field. I'm just looking for a sample code though of someone else performing a update request using Restsharp. I could write it all out in a string but I'm hoping for a easier way then using a string and passing as a parameter.
Edit
I'm currently trying to do it by building a string to pass in as the parameter. I know there has to be a better way. Here is my current progress on building a string;
Postman String:
request.AddParameter("application/javascript", "[\n {\n \"operation\": \"replace\",\n \"field\": \"/userName\",\n \"value\": \"testuser4@aha.org\"\n },\n {\n \"operation\": \"replace\",\n \"field\": \"/mail\",\n \"value\": \"testuser4@aha.org\"\n }\n]", ParameterType.RequestBody);
My string builder function in progress:
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
string Update = string.Empty;
string UpdateOperation = '"' + "operation" + '"' + ": " + '"' + "replace\"" + ",\n" + '"';
string Updatefield = "field" + '"' + ": \"";
string UpdateNewValue = "/" + newvalue + '"' + ",\n";
string
// "[\n {\n \"operation\": \"replace\",\n\"
// field\": \"
// /userName\",\n
// \"value\": \"testuser4@aha.org\"\n },\n {\n \"operation\": \"replace\",\n \"field\": \"/mail\",\n \"value\": \"testuser4@aha.org\"\n }\n]"
return Update;
}
catch(Exception ex)
{
return null;
}
}
Anyone have a better way to do this?
I'm very new still to Rest Sharp and Postman but I'm trying to make a "Update" to an existing user. Here is my code but I know its wrong. Does anyone have samples on how to perform a "replace" operation in Rest Sharp?
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + obj.userName.ToString();
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate();
//if (Update != null)
//{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
//request.AddParameter("application/json", "[\n {\n \"operation\": \"replace\",\n \"field\": \"/userName\",\n \"value\": \"testuser4@aha.org\"\n },\n {\n \"operation\": \"replace\",\n \"field\": \"/mail\",\n \"value\": \"testuser4@aha.org\"\n }\n]", ParameterType.RequestBody);
request.AddBody({ "operation": "replace", "field": "/userName", "value": "testuser4@aha.org"}, { "operation": "replace", "field": "/mail", "value": "testuser4@aha.org"});
IRestResponse response = client.Execute(request);
Postman says it should be something like this:
[
{
"operation": "replace",
"field": "/userName",
"value": "testuser4@aha.org"
},
{
"operation": "replace",
"field": "/mail",
"value": "testuser4@aha.org"
}
]
I would prefer to write it that way but I have no idea how. The other code suggested I make a string. I can write it out via string but Id prefer to write it out in the body if I can or possible. Thanks in advance
Edit:
Here is my class:
public class IdentityDetails
{
//public const string type = "user";
//public const string realm = "dc=aha,dc=org";
public string userName { get; set; }
public string mail { get; set; }
public string givenName { get; set; }
public string sn { get; set; }
public string accountStatus { get; set; }
public string avectraId { get; set; }
public string AHApw { get; set; }
public string password { get; set; }
public string ahaBirthYear { get; set; }
public string city { get; set; }
public string ahaGender { get; set; }
public string ahaJobTitle { get; set; }
public string ahaLeadScore { get; set; }
public string stateProvince { get; set; }
public string orgId { get; set; }
public string[] ahaMemberGroup { get; set; }
public string[] ahaMemberType { get; set; }
public string regMethod { get; set; }
//public string[] ahaDrupalPermission { get; set; }
}
I think what I need to do though as well will be pass in the current field and value, and pass in the new value for the field. I'm just looking for a sample code though of someone else performing a update request using Restsharp. I could write it all out in a string but I'm hoping for a easier way then using a string and passing as a parameter.
Edit
I'm currently trying to do it by building a string to pass in as the parameter. I know there has to be a better way. Here is my current progress on building a string;
Postman String:
request.AddParameter("application/javascript", "[\n {\n \"operation\": \"replace\",\n \"field\": \"/userName\",\n \"value\": \"testuser4@aha.org\"\n },\n {\n \"operation\": \"replace\",\n \"field\": \"/mail\",\n \"value\": \"testuser4@aha.org\"\n }\n]", ParameterType.RequestBody);
My string builder function in progress:
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
string Update = string.Empty;
string UpdateOperation = '"' + "operation" + '"' + ": " + '"' + "replace\"" + ",\n" + '"';
string Updatefield = "field" + '"' + ": \"";
string UpdateNewValue = "/" + newvalue + '"' + ",\n";
string
// "[\n {\n \"operation\": \"replace\",\n\"
// field\": \"
// /userName\",\n
// \"value\": \"testuser4@aha.org\"\n },\n {\n \"operation\": \"replace\",\n \"field\": \"/mail\",\n \"value\": \"testuser4@aha.org\"\n }\n]"
return Update;
}
catch(Exception ex)
{
return null;
}
}
Anyone have a better way to do this?
ANSWER
Answered 2017-Oct-24 at 14:20I think I found the answer to my problem. I'm not sure if I have this in the right order but I got the string formatted correctly. I hope this helps someone else as well.
Here is my base function for performing my REST update request using Restsharp:
public string UpdateRequest(string uid, string field, string newvalue, string oldvalue)
{
try
{
string url = _EndPoint + "?_action = patch & _queryId =for-userName & uid =" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, newvalue, oldvalue);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
I'm calling my BuildUpdate function to return my Json string that I will use to pass in as my parameter. Here is my function to build the update string. I broke it up into two parts and converted each part into a json string format. Then I combine them into a single string:
private string BuildUpdate(string field, string newvalue, string oldvalue)
{
try
{
//Parameter String
string Update = string.Empty;
//New Value
var dict1 = new Dictionary<string, string>();
dict1.Add("operation", "replace");
dict1.Add("field", field);
dict1.Add("value", newvalue);
string json1 = Regex.Unescape(JsonConvert.SerializeObject(dict1, Newtonsoft.Json.Formatting.Indented));
//Current Value
var dict2 = new Dictionary<string, string>();
dict2.Add("operation", "replace");
dict2.Add("field", field);
dict2.Add("value", oldvalue);
string json2 = Regex.Unescape(JsonConvert.SerializeObject(dict2, Newtonsoft.Json.Formatting.Indented));
Update = json1 + ",\n " + json2;
return Update;
}
catch(Exception ex)
{
return null;
}
}
Here is my output string I will pass in as my parameter:
"{\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser999@aha.org\"\r\n},\n {\r\n \"operation\": \"replace\",\r\n \"field\": \"userName\",\r\n \"value\": \"testuser4@aha.org\"\r\n}"
Update: I just wanted to share my working code sample with everyone.
Function 1:
public string UpdateRequest(string uid, string field, string value)
{
try
{
string url = _EndPoint + "?_action=patch&_queryId=for-userName&uid=" + uid;
var client = new RestClient(url);
var request = new RestRequest(Method.POST);
string username = "openidm-admin";
string password = "openidm-admin";
string svcCredentials = Convert.ToBase64String(ASCIIEncoding.ASCII.GetBytes(username + ":" + password));
string Update = BuildUpdate(field, value);
if (Update != null)
{
request.AddHeader("Authorization", "Basic " + svcCredentials);
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", Update, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
return response.Content.ToString();
}
else
{
//Error
return "Error";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
Here is the string building function to build your Json string for the request:
private string BuildUpdate(string field, string value)
{
try
{
//Parameter String
string json = string.Empty;
//Value
var dict = new Dictionary<string, string>();
dict.Add("operation", "replace");
dict.Add("field", field);
dict.Add("value", value);
json = "[\n" + Regex.Unescape(JsonConvert.SerializeObject(dict, Newtonsoft.Json.Formatting.Indented)) + "\n]";
return json;
}
catch(Exception ex)
{
return null;
}
}
I'm not sure why I have to add "[\n" or "\n]" but I assume its wrapping it for some reason. Anyway, I hope this helps someone.
QUESTION
How to test OpenIm (ForgeRock) Request on Postman?
Asked 2017-Oct-17 at 12:50I have openIdm ForgeRock installed locally and I'am trying to go through the API Explorer etc. in order to see how to use the endpoints and the available endpoints.
From localhost:8080 where ForgeRock is running I can run/try a request. It works fine and I see the Response with Status 200 and its details.
When I try same Request URL on Postman, I get:
{
"code": 401,
"reason": "Unauthorized",
"message": "Access Denied"
}
In a way this makes sense for me as I'am not logged in in this case as directly via ForgeRock Server on localhost:8080. So how can I work around this to be able to run my tests also on Postman.
I tried the parameters username=xxx and password=xxx to the Request on Postman, but it keeps throwing the same error.
I also tried it on Postman as CURL request exactly how ForgeRock is using it, but it seems to have an issue with Authorization.
curl -X GET --header 'Accept: application/json' --header 'X-Requested-With: Swagger-UI' 'http://localhost:8080/openidm/managed/user?_queryId=query-all'
Any Idea please?
I have openIdm ForgeRock installed locally and I'am trying to go through the API Explorer etc. in order to see how to use the endpoints and the available endpoints.
From localhost:8080 where ForgeRock is running I can run/try a request. It works fine and I see the Response with Status 200 and its details.
When I try same Request URL on Postman, I get:
{
"code": 401,
"reason": "Unauthorized",
"message": "Access Denied"
}
In a way this makes sense for me as I'am not logged in in this case as directly via ForgeRock Server on localhost:8080. So how can I work around this to be able to run my tests also on Postman.
I tried the parameters username=xxx and password=xxx to the Request on Postman, but it keeps throwing the same error.
I also tried it on Postman as CURL request exactly how ForgeRock is using it, but it seems to have an issue with Authorization.
curl -X GET --header 'Accept: application/json' --header 'X-Requested-With: Swagger-UI' 'http://localhost:8080/openidm/managed/user?_queryId=query-all'
Any Idea please?
ANSWER
Answered 2017-Oct-17 at 12:50Fixed. Was actually simple... Had to add the following in the headers:
X-OpenIDM-Username
X-OpenIDM-Password
Value is by default: opendidm-admin for both.
QUESTION
Ajax Header Request "X-openIDM-Reauth-Password" not working
Asked 2017-Jul-03 at 05:12I have an openIDM program and when users submit for update new password , it show "X-openIDM-Reauth-Password" which include my old password that i need to retype. Following is the screen shot from openidm side.
So, i have my own UI and i was request from javascript ajax side with following ajax call.
$.ajax({
contentType: "application/json; charset=UTF-8",
datatype: 'json',
url: targetHost+"openidm/managed/user/"+userId,
xhrFields: {
withCredentials: true,
},
headers: {
"X-Requested-With":"XMLHttpRequest" ,
"X-OpenIDM-Reauth-Password": oldPassword
},
crossDomain:true,
data: JSON.stringify(data),
type: 'PATCH',
success:function(result) {
console.log("success");
swal({
title: updateSuccessMsgs.formSubmit.slogan,
text: updateSuccessMsgs.formSubmit.success,
type: "success"
}, function() {
window.location = "my-profile.html";
});
},
error:function (error){
sweetAlert(updateErrorMsgs.updateError.slogan, updateErrorMsgs.updateError.fail, "error");
console.log(error);
}
});
and it throw me this error.
XMLHttpRequest cannot load http://localhost:9090/openidm/managed/user/09096425-4ff1-42d4-8a4d-3a6b5004afca. Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost' is therefore not allowed access.
Can someone explain me why? Appreciate it.
I have an openIDM program and when users submit for update new password , it show "X-openIDM-Reauth-Password" which include my old password that i need to retype. Following is the screen shot from openidm side.
So, i have my own UI and i was request from javascript ajax side with following ajax call.
$.ajax({
contentType: "application/json; charset=UTF-8",
datatype: 'json',
url: targetHost+"openidm/managed/user/"+userId,
xhrFields: {
withCredentials: true,
},
headers: {
"X-Requested-With":"XMLHttpRequest" ,
"X-OpenIDM-Reauth-Password": oldPassword
},
crossDomain:true,
data: JSON.stringify(data),
type: 'PATCH',
success:function(result) {
console.log("success");
swal({
title: updateSuccessMsgs.formSubmit.slogan,
text: updateSuccessMsgs.formSubmit.success,
type: "success"
}, function() {
window.location = "my-profile.html";
});
},
error:function (error){
sweetAlert(updateErrorMsgs.updateError.slogan, updateErrorMsgs.updateError.fail, "error");
console.log(error);
}
});
and it throw me this error.
XMLHttpRequest cannot load http://localhost:9090/openidm/managed/user/09096425-4ff1-42d4-8a4d-3a6b5004afca. Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost' is therefore not allowed access.
Can someone explain me why? Appreciate it.
ANSWER
Answered 2017-Jul-03 at 05:12I found the solution. I try to add one more value in servletfilter-cors.json as follow. I added the value of "X-OpenIDM-Reauth-Password" in "allowedHeaders" and it is success.
{
"classPathURLs" : [ ],
"systemProperties" : { },
"requestAttributes" : { },
"scriptExtensions" : { },
"initParams" : {
"allowedOrigins" : "*",
"allowedMethods" : "GET,POST,PUT,DELETE,PATCH",
"allowedHeaders" : "accept,x-openidm-password,x-openidm-nosession,x-openidm-username,content-type,origin,X-OpenIDM-Reauth-Password,x-requested-with",
"allowCredentials" : "true",
"chainPreflight" : "false"
},
"urlPatterns" : [
"/*"
],
"filterClass" : "org.eclipse.jetty.servlets.CrossOriginFilter"
}
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
VULNERABILITIES
CVE-2017-7590 MEDIUM
OpenIDM through 4.0.0 and 4.5.0 is vulnerable to persistent cross-site scripting (XSS) attacks within the Admin UI, as demonstrated by a crafted Managed Object Name.
CVE-2017-7589 MEDIUM
In OpenIDM through 4.0.0 before 4.5.0, the info endpoint may leak sensitive information upon a request by the "anonymous" user, as demonstrated by responses with a 200 HTTP status code and a JSON object containing IP address strings. This is related to a missing access-control check in bin/defaults/script/info/login.js.
CVE-2017-7591 MEDIUM
OpenIDM through 4.0.0 and 4.5.0 is vulnerable to reflected cross-site scripting (XSS) attacks within the Admin UI, as demonstrated by the _sortKeys parameter to the authzRoles script under managed/user/.
INSTALL OpenIDM
You can use OpenIDM like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the OpenIDM component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .
SUPPORT
For any new features, suggestions and bugs create an issue on GitHub.
If you have any questions check and ask questions on community page Stack Overflow .
Reuse or Be Inspired by popular libraries in your Industry or Technology​
Add this library and start creating your kit
Implement OpenIDM faster with kandi.
- Use the support, quality, security, license, reuse scores and reviewed functions to confirm the fit for your project.
- Use the, Q & A, Installation and Support guides to implement faster.
Discover Millions of Libraries and
Pre-built Use Cases on kandi
