Forum Discussion

Anuj6's avatar
Anuj6
Frequent Visitor
6 years ago

Dynamically pass query in POST API BODY

Hello All,   I am trying to connect to an internal application using REST API POST method, for this i have created one Custom Connector. When i am passing static query ( Select * from Table ) into...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anuj6 ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

 

  • Anuj6's avatar
    Anuj6
    Frequent Visitor
    6 years ago

    Hi Team,

     

    Apologies for delay in response, i was on leave so couldnt try out the solution you provided.

    Will do it and provide you the feedback soon.

     

    Thanks!

    Anuj 

  • Anuj6's avatar
    Anuj6
    Frequent Visitor
    6 years ago

    Hi Dong_li,

    No , it didnt work for me , i was trying to pass some of the Body parameters dynamically.

    Though i achieved it using below code

     

    GetTable1 = (url as text,DS_ID as text,tb_nm as text) =>

    let

    body =
    "{""queryConfigurationDto"": {

    ""configurationName"":""TEST"",
    ""applicationId"":""ABT_4ba6bf1d-f1ac-4efd-a58e-4c79234dse"",
    ""configAdgroups"":[""ALL_ACCESS""],
    ""readAdgroups"":[""ALL_ACCESS""],
    ""decryptionAccessAdGroups"":[],
    ""configurationType"":""QUERY"",
    ""dataSourceConfigurationId"":"""& DS_ID &""",
    ""query"":""select * from "& tb_nm &" LIMIT 1000"",
    ""mandatoryParams"":[],
    ""encryptedParams"":[],
    ""paramValues"":{}},
    ""dataAccessRequest"":{""parameters"":{},""responseFormat"":"" ""}}",

     

    Thanks!

    Anuj