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
  • Krishna's avatar
    Krishna
    Valued Contributor
    4 years ago

    Thanks Sai. Let me go through the BR and update you.

     

    Krishna

  • ckattookaran's avatar
    ckattookaran
    Valued Contributor
    4 years ago

    Sai, your BR is not doing any filtering, or did I miss that part?

    • Sai_Maganti's avatar
      Sai_Maganti
      Contributor II
      4 years ago

      All I understood about the OPs post was how to get data from an api call and use it in a data source. Not sure if the OP wanted to filter data?

  • Krishna's avatar
    Krishna
    Valued Contributor
    4 years ago

    FYI  - I am using the Public Async Function APIC(ByVal si As SessionInfo) As Task. As you see the return type is task for the API so I will not be able to pass this to the Get data function. I took a different route I created a Temp Table and inserted the API response into the table then I used normal SQL Connector function to bring it to the data source. This works for me and was able to lad the Employee data into the Cube.  BTW thanks for your post and it was helpful.