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).

 

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 🙂

    • Sai_Maganti's avatar
      Sai_Maganti
      Contributor II
      4 years ago

      CK

      Further looking into the Golfstream app and other connector samples "ClientFilterRequest" and "ClientSortRequest" were exclusively used in DrillBack functions.
      Maybe this is just a check to see if there is a "Where" and "Order By" clauses in the drill back sql and accordingly add those clauses into the SQL String..Just my 2 cents.