The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
4 years ago

RESTAPI from HCM Cloud

Hi - I have created a routine in Connector Rule to fetch the Worker data from HCM and I was able to assign it to a variables and able to print it successfully.   My question is below    1. Ho...
Connectors
ckattookaran's avatar
ckattookaran
Valued Contributor
4 years ago

I did ask around how to use the ClientFilterRequest method in the connector. However, there is nothing in the documentation around it or how to pass that to the connector rule. Maybe this is not exposed in the UI.

Long story short, I don't think you can pass a parameter or filter to the connector rule (even though a method is there).

 

  • Krishna's avatar
    Krishna
    Valued Contributor
    4 years ago

    ClientFilterRequest  - Are you referring to pass query parameters to the API ? 

     

    Thanks

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      Yup, that is part of ConnectorArgs. However, there is no way to pass it though. It is there but can't use (or I'm not sure how to use it)

      • Krishna's avatar
        Krishna
        Valued Contributor
        4 years ago

        In my function I used the below to pass the query parameter and checking with the current date. I am not sure I am answered your question. Let me know if this helps

        Dim Baseurl As String = "BaseUrl"
        Dim Qry As String = "?q=EffectiveStartDate>"+Dt+"&onlyData=True"
        Dim FinalUrl = Baseurl + Qry

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      Isn't that what you meant by this?

      Krishna wrote:

      Hi - I have created a routine in Connector Rule to fetch the Worker data from HCM and I was able to assign it to a variables and able to print it successfully.

       

      My question is below 

       

      1. How I can assign the variables to the List because I am trying to use this connector rule in Data Source and trying to bring the data to the OS stage Area ? is it possible, My function return type is task for the RESTAPI call.

       

      Thanks

       

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    4 years ago

    Usually you pass the filter args while calling the BR and with in the connector BR you would use

    args.ClientFilterRequest.length > 0 then
    'do your filtering here. if SQL then Where predicate..if api then pass this to the querystring..

     

    • ckattookaran's avatar
      ckattookaran
      Valued Contributor
      4 years ago

      Can you please show me where to use this? For the life of me, I cannot find a way to do it.

      • Sai_Maganti's avatar
        Sai_Maganti
        Contributor II
        4 years ago

        Well I haven't used this before but just reading in the ref manual..I will let you know if I find out how to 🙂