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
Icon for Community Support rankCommunity 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 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