Reltio Connect

 View Only

  • 1.  How to export values for nested attributes from Relationship API in Reltio

    Posted 21 days ago
      |   view attached

    Hi All,

    I need to export data from POSTMAN to get relationship attributes(eid,parent eid,parent name,child eid,child name)

    Please find my filter and select in used in Postman

    filter equals(type,'configuration/relationTypes/AlternateCompanyRel')

    select startObject,
    endObject,
    type,uri,updatedBy,updateDate,createDate
    I am not getting startObject and endObject values in export.
    Only getting results for below attributes.
    "uri","Type","updatedBy","updateDate","createDate"

    Please help to write select for nested attributes.

    Attached is sample get Relations Response  to refer attributes used.

    Thanks

    Shruti



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Attachment(s)

    txt
    SampleGetRelationsResponse.txt   3 KB 1 version


  • 2.  RE: How to export values for nested attributes from Relationship API in Reltio

    Reltio Employee
    Posted 19 days ago

    Hi Shruti,

    Please try the below syntax for specifying the attributes in the select parameter:

    GET {{tenantURL}}/relations?filter=(equals(endObject,'0rzd5Dg')&select=uri,createdBy,startObject,endObject,attributes.Role

    Let me know if it works



    ------------------------------
    Thanks,
    Snehil Kamal
    Solution Architect
    Reltio
    Bangalore
    ------------------------------

    Original Message


  • 3.  RE: How to export values for nested attributes from Relationship API in Reltio

    Posted 19 days ago

    Hi Snehil,

    Thanks for your revert.

    Please check my request and response I tried as per your suggestions.

    Request-

    GET {{tenantURL}}/relations?filter=(equals(endObject,'0sbZHLp')&select=uri,createdBy,startObject,endObject,attributes.Role

    Response is attached in file.

    Thanks

    Shruti Das



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


  • 4.  RE: How to export values for nested attributes from Relationship API in Reltio

    Reltio Employee
    Posted 19 days ago

    Hi Shruti,

    For some reason, I don't see any attachments. Did you get the attribute in response? Please note that the "Role" attribute should be present inside your relationType for this to work



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Solution Architect
    Reltio
    Bangalore
    ------------------------------

    Original Message


  • 5.  RE: How to export values for nested attributes from Relationship API in Reltio

    Posted 19 days ago

    Hi Snehil,

    I am not getting startObject and endObject in export file.

    When I do GET I am getting response I mentioned in above comment and there is all attributes including startObject and endObject.

    But when I do POST for export I am not getting these values. In above chat I have mentioned request response for export as well.

    Can we do it with attribute projection? If yes then how can we do?

    Thanks

    Shruti Das



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


  • 6.  RE: How to export values for nested attributes from Relationship API in Reltio

    Reltio Employee
    Posted 19 days ago

    Hi Shruti,

    See the highlighted note from the documentation

    The workaround is to get rid of the select parameter while exporting. You will get start and end object crosswalks that way.



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Solution Architect
    Reltio
    Bangalore
    ------------------------------

    Original Message


  • 7.  RE: How to export values for nested attributes from Relationship API in Reltio

    Posted 15 days ago

    Hi Snehil,

    Just checked this screenshot of Document where it says that startObject and endObject are not supported in export.

    Also you have mentioned one point

    "The workaround is to get rid of the select parameter while exporting. You will get start and end object crosswalks that way."

    -Does this means we dont need to mention anything in select statement to get all values in crosswalk.

    Because I already tried that and it was giving Company.id,Company.name

    T

    https://test.reltio.com/jobs/export/IB5D4yLF6NGP0P2/relations/?filter=equals(type,'configuration/relationTypes/AlternateCompanyRel')&select=select 
    type,uri,crosswalks,updatedBy,updateDate,createDate&fileFormat=csv&distributed=true&taskPartsCount=7&partSize=4000mb

    Thanks

    Shruti



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


  • 8.  RE: How to export values for nested attributes from Relationship API in Reltio

    Reltio Employee
    Posted 15 days ago

    Hi Shruti,

    I can see you still have a select parameter in your API request. Can you try removing that and see what you get in the output?



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Solution Architect
    Reltio
    Bangalore
    ------------------------------

    Original Message


  • 9.  RE: How to export values for nested attributes from Relationship API in Reltio

    Posted 15 days ago

    Hi Snehil,

    If we remove select then we are getting unwanted attributes.Attached file.

    Is there a way to get rid of unwanted columns as we are getting many columns of crosswalks.

    Also we are trying now with json file format

    We are receiving below response with json file format for single entity.

    Request - https://test.reltio.com/jobs/export/IB5D4yLF6NGP0P2/relations/?filter=equals(type,'configuration/relationTypes/AlternateCompanyRel') and(equals(endObject,'0sbZHLp')&select=type,uri,createdBy,startObject,endObject,attributes.Role&fileFormat=json&distributed=true&taskPartsCount=7&partSize=4000mb

    Response

    [

    {"uri":"relations/uPxzSkc","type":"configuration/relationTypes/AlternateCompanyRel","createdBy":jason.grant@optum.com,"attributes":{},"startObject":{"type":"configuration/entityTypes/Company","objectURI":"entities/694JdZv","label":"Southern Ohio Medical Center","directionalLabel":"Alternate Parent Company","crosswalks":[{"uri":"entities/694JdZv/crosswalks/AY9VkpXr","type":"configuration/sources/Reltio","value":"694JdZv","reltioLoadDate":"2024-04-10T16:36:33.526Z","createDate":"2019-04-12T21:52:18.493Z","updateDate":"2019-04-12T21:52:18.493Z","attributes":["entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5"],"singleAttributeUpdateDates":{"entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5":"2019-04-12T21:52:18.493Z"}}]},"endObject":{"type":"configuration/entityTypes/Company","objectURI":"entities/0sbZHLp","label":"SOMC Home Health","directionalLabel":"Alternate Child Company","crosswalks":[{"uri":"entities/0sbZHLp/crosswalks/5L16Y3uf","type":"configuration/sources/Reltio","value":"0sbZHLp","reltioLoadDate":"2023-09-21T18:55:45.193Z","createDate":"2023-09-21T18:55:45.193Z","updateDate":"2023-09-21T18:55:45.193Z","attributes":[],"singleAttributeUpdateDates":{}}]}}

    ]

    -Note -if we try for multiple entities we will get multiple crosswalks which will blow up the columns again.

    Can you help us to get limited attributes?

    Thanks

    Shruti Das



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


  • 10.  RE: How to export values for nested attributes from Relationship API in Reltio

    Posted 13 days ago

    Hi Snehil,

    If we do not use select in postman we get all columns and startEntity as Companyid.

    But  issue is we don't want so many columns .Attached file.

    Also we tried with json format with below select and filter

    https://test.reltio.com/jobs/export/IB5D4yLF6NGP0P2/relations?filter=equals(type,'configuration/relationTypes/AlternateCompanyRel')&fileFormat=json&select=type,uri,createdBy,startObject,endObject

    Here we are getting crosswalk columns also. I will paste response at the end.

    Please help if we can get rid of crosswalk value in export from API call in file format json.

    Our requirement is to get only these values  and no crosswalk value,File format can be json

    type,uri,createdBy,startObject,endObject

    Request -

    https://test.reltio.com/jobs/export/IB5D4yLF6NGP0P2/relations?filter=equals(type,'configuration/relationTypes/AlternateCompanyRel')and(equals(endObject,'0sbZHLp'&fileFormat=json&select=type,uri,createdBy,startObject,endObject)

    Response

    [
    {"uri":"relations/uPxzSkc","type":"configuration/relationTypes/AlternateCompanyRel","createdBy":"jason.grant@optum.com","startObject":{"type":"configuration/entityTypes/Company","objectURI":"entities/694JdZv","label":"Southern Ohio Medical Center","directionalLabel":"Alternate Parent Company","crosswalks":[{"uri":"entities/694JdZv/crosswalks/AY9VkpXr","type":"configuration/sources/Reltio","value":"694JdZv","reltioLoadDate":"2024-04-10T16:36:33.526Z","createDate":"2019-04-12T21:52:18.493Z","updateDate":"2019-04-12T21:52:18.493Z","attributes":["entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5"],"singleAttributeUpdateDates":{"entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ":"2019-04-12T21:52:18.493Z","entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5":"2019-04-12T21:52:18.493Z"}}]},"endObject":{"type":"configuration/entityTypes/Company","objectURI":"entities/0sbZHLp","label":"SOMC Home Health","directionalLabel":"Alternate Child Company","crosswalks":[{"uri":"entities/0sbZHLp/crosswalks/5L16Y3uf","type":"configuration/sources/Reltio","value":"0sbZHLp","reltioLoadDate":"2023-09-21T18:55:45.193Z","createDate":"2023-09-21T18:55:45.193Z","updateDate":"2023-09-21T18:55:45.193Z","attributes":[],"singleAttributeUpdateDates":{}}]}}
    ]

    Thanks

    Shruti Das



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


  • 11.  RE: How to export values for nested attributes from Relationship API in Reltio

    Posted 19 days ago

    Hi Snehil,

    Below is my response for that request.

    [
        {
            "uri": "relations/uPxzSkc",
            "createdBy": "abc@optum.com",
            "attributes": {},
            "startObject": {
                "type": "configuration/entityTypes/Company",
                "objectURI": "entities/694JdZv",
                "label": "Southern Ohio Medical Center",
                "directionalLabel": "Alternate Parent Company",
                "crosswalks": [
                    {
                        "uri": "entities/694JdZv/crosswalks/AY9VkpXr",
                        "type": "configuration/sources/Reltio",
                        "value": "694JdZv",
                        "reltioLoadDate": "2024-04-10T16:36:33.526Z",
                        "createDate": "2019-04-12T21:52:18.493Z",
                        "updateDate": "2019-04-12T21:52:18.493Z",
                        "attributes": [
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5"
                        ],
                        "singleAttributeUpdateDates": {
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdateTime/AY9Vkh1L": "2019-04-12T21:52:18.493Z",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/Status/AY9VkYUp": "2019-04-12T21:52:18.493Z",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/UpdatedBy/AY9VklHb": "2019-04-12T21:52:18.493Z",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ": "2019-04-12T21:52:18.493Z",
                            "entities/694JdZv/attributes/StewardshipStatus/AY9VkUEZ/NeedsStewardship/AY9Vkcl5": "2019-04-12T21:52:18.493Z"
                        }
                    }
                ]
            },
            "endObject": {
                "type": "configuration/entityTypes/Company",
                "objectURI": "entities/0sbZHLp",
                "label": "SOMC Home Health",
                "directionalLabel": "Alternate Child Company",
                "crosswalks": [
                    {
                        "uri": "entities/0sbZHLp/crosswalks/5L16Y3uf",
                        "type": "configuration/sources/Reltio",
                        "value": "0sbZHLp",
                        "reltioLoadDate": "2023-09-21T18:55:45.193Z",
                        "createDate": "2023-09-21T18:55:45.193Z",
                        "updateDate": "2023-09-21T18:55:45.193Z",
                        "attributes": [],
                        "singleAttributeUpdateDates": {}
                    }
                ]
            }
        }
    ]
    I am trying to export as well but not happening.
    I using below request for export
    Request
    https://test.reltio.com/jobs/export/IB5D4yLF6NGP0P2/relations/?filter=equals(type,'configuration/relationTypes/AlternateCompanyRel') and (equals(startObject,'694JdZv')(equals(endObject,'0sbZHLp')&select=type,uri,createdBy,startObject,endObject,attributes.Role&fileFormat=csv&distributed=true&taskPartsCount=7&partSize=4000mb
    Response only getting attributes
    "uri","Type","createdBy"
    "relations/uPxzSkc","AlternateCompanyRel","abc@optum.com"
    Thanks
    Shruti



    ------------------------------
    Shruti Das
    Optum
    ------------------------------

    Original Message


Related Content