How can we get the start and end date from a RIH Reltio connector and format the EpochDate?

Question

I am currently using the "Get record details by ID" action in RIH and attempting to retrieve the relationship details. However, I have noticed that the "Start date and end date" attributes are not being returned when attempting to retrieve details using the relationship ID. I have also attached the output response for your reference.

Answer

• Start/end date is not returned in the data pill when using the Reltio connector in RIH.
• Create a custom action using HTTP request that simply executes a API call (in the example below you are performing a GET relations/<id>.

• Schema defined in custom action.

[
{
"control_type": "text",
"label": "URI",
"type": "string",
"name": "uri"
},
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Created by",
"type": "string",
"name": "createdBy"
},
{
"control_type": "number",
"label": "Created time",
"parse_output": "float_conversion",
"type": "number",
"name": "createdTime"
},
{
"control_type": "text",
"label": "Updated by",
"type": "string",
"name": "updatedBy"
},
{
"control_type": "number",
"label": "Updated time",
"parse_output": "float_conversion",
"type": "number",
"name": "updatedTime"
},
{
"control_type": "number",
"label": "End date",
"parse_output": "float_conversion",
"type": "number",
"name": "endDate"
},
{
"control_type": "number",
"label": "Start date",
"parse_output": "float_conversion",
"type": "number",
"name": "startDate"
},
{
"control_type": "text",
"label": "Start ref pinned",
"render_input": {},
"parse_output": {},
"toggle_hint": "Select from option list",
"toggle_field": {
"label": "Start ref pinned",
"control_type": "text",
"toggle_hint": "Use custom value",
"type": "boolean",
"name": "startRefPinned"
},
"type": "boolean",
"name": "startRefPinned"
},
{
"control_type": "text",
"label": "Start ref ignored",
"render_input": {},
"parse_output": {},
"toggle_hint": "Select from option list",
"toggle_field": {
"label": "Start ref ignored",
"control_type": "text",
"toggle_hint": "Use custom value",
"type": "boolean",
"name": "startRefIgnored"
},
"type": "boolean",
"name": "startRefIgnored"
},
{
"control_type": "text",
"label": "End ref pinned",
"render_input": {},
"parse_output": {},
"toggle_hint": "Select from option list",
"toggle_field": {
"label": "End ref pinned",
"control_type": "text",
"toggle_hint": "Use custom value",
"type": "boolean",
"name": "endRefPinned"
},
"type": "boolean",
"name": "endRefPinned"
},
{
"control_type": "text",
"label": "End ref ignored",
"render_input": {},
"parse_output": {},
"toggle_hint": "Select from option list",
"toggle_field": {
"label": "End ref ignored",
"control_type": "text",
"toggle_hint": "Use custom value",
"type": "boolean",
"name": "endRefIgnored"
},
"type": "boolean",
"name": "endRefIgnored"
},
{
"properties": [
{
"name": "Quantity",
"type": "array",
"of": "object",
"label": "Quantity",
"properties": [
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Ov",
"render_input": {},
"parse_output": {},
"toggle_hint": "Select from option list",
"toggle_field": {
"label": "Ov",
"control_type": "text",
"toggle_hint": "Use custom value",
"type": "boolean",
"name": "ov"
},
"type": "boolean",
"name": "ov"
},
{
"control_type": "text",
"label": "Value",
"type": "string",
"name": "value"
},
{
"control_type": "text",
"label": "URI",
"type": "string",
"name": "uri"
}
]
}
],
"label": "Attributes",
"type": "object",
"name": "attributes"
},
{
"name": "crosswalks",
"type": "array",
"of": "object",
"label": "Crosswalks",
"properties": [
{
"control_type": "text",
"label": "URI",
"type": "string",
"name": "uri"
},
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Value",
"type": "string",
"name": "value"
},
{
"control_type": "text",
"label": "Reltio load date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "reltioLoadDate"
},
{
"control_type": "text",
"label": "Create date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "createDate"
},
{
"control_type": "text",
"label": "Update date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "updateDate"
},
{
"name": "attributes",
"type": "array",
"of": "string",
"control_type": "text",
"label": "Attributes"
},
{
"properties": [],
"label": "Single attribute update dates",
"type": "object",
"name": "singleAttributeUpdateDates"
}
]
},
{
"properties": [
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Object URI",
"type": "string",
"name": "objectURI"
},
{
"control_type": "text",
"label": "Label",
"type": "string",
"name": "label"
},
{
"control_type": "text",
"label": "Directional label",
"type": "string",
"name": "directionalLabel"
},
{
"name": "crosswalks",
"type": "array",
"of": "object",
"label": "Crosswalks",
"properties": [
{
"control_type": "text",
"label": "URI",
"type": "string",
"name": "uri"
},
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Value",
"type": "string",
"name": "value"
},
{
"control_type": "text",
"label": "Reltio load date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "reltioLoadDate"
},
{
"control_type": "text",
"label": "Create date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "createDate"
},
{
"control_type": "text",
"label": "Update date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "updateDate"
},
{
"properties": [],
"label": "Single attribute update dates",
"type": "object",
"name": "singleAttributeUpdateDates"
}
]
}
],
"label": "Start object",
"type": "object",
"name": "startObject"
},
{
"properties": [
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Object URI",
"type": "string",
"name": "objectURI"
},
{
"control_type": "text",
"label": "Label",
"type": "string",
"name": "label"
},
{
"control_type": "text",
"label": "Directional label",
"type": "string",
"name": "directionalLabel"
},
{
"name": "crosswalks",
"type": "array",
"of": "object",
"label": "Crosswalks",
"properties": [
{
"control_type": "text",
"label": "URI",
"type": "string",
"name": "uri"
},
{
"control_type": "text",
"label": "Type",
"type": "string",
"name": "type"
},
{
"control_type": "text",
"label": "Value",
"type": "string",
"name": "value"
},
{
"control_type": "text",
"label": "Reltio load date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "reltioLoadDate"
},
{
"control_type": "text",
"label": "Create date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "createDate"
},
{
"control_type": "text",
"label": "Update date",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion",
"type": "date_time",
"name": "updateDate"
},
{
"properties": [],
"label": "Single attribute update dates",
"type": "object",
"name": "singleAttributeUpdateDates"
}
]
}
],
"label": "End object",
"type": "object",
"name": "endObject"
}
]

• Format epoch date to apply a human readable format.

• Generated output

{
"StartDate": "05/01/23",
"EndDate": "07/31/23"
}