Reltio Connect

 View Only
  • 1.  Delete Lookup Table Entries via API

    Reltio Partner
    Posted 08-27-2024 09:37

    Hello,

    Is there any API from which we can delete the lookup table entries in RIH? I've came across this on workato docs - Workato API - Lookup Tables | Workato Docs but I'm getting unauthorized response from POSTMAN.

    Workato remove preview
    Workato API - Lookup Tables | Workato Docs
    product docs

     .

    Thanks,
    Hardik Singhavi.



    ------------------------------
    Hardik Singhavi
    freshgravity
    ------------------------------


  • 2.  RE: Delete Lookup Table Entries via API

    Reltio Employee
    Posted 08-28-2024 10:14

    Hi Hardik, 

    Since these are Workato Native APIs, you will not be able to trigger those using the Reltio Authentication Method. You will need to create Workato API client and client role with relevant permissions to generate API Token which will then need to be used from the APIs you shared. 

    Refer to the following documentation to understand how to create a client ID and client role - https://docs.workato.com/workato-api/api-clients.html#create-an-api-client

    If my understanding is correct, you will need to add the following permissions (selective or all) to the role 


    Please note that you can only see the API Client and Client roles option in RIH if you have ROLE_INTEGRATION_CUSTOMER_ADMIN in your user


    Alternatively, you can also delete the lookup table data by creating a recipe and using the Workato Lookup Table connector itself. There are three actions which can be used in this case 

    • Delete Entry
    • Delete Multiple entries
    • Truncate Table



    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------