Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Connect to a Web Service sending parameters

Hi Community   I am trying to access a wb API. I am connecting using web connector. I need data based upon some query valuess. I am able to access the website for the basic table, but not sure how...
Need Help
  • MAS42's avatar
    MAS42
    Frequent Visitor
    3 years ago

    Hi ImkeF. 

     

    I'm afraid I have yet Another API question.

     

    I am new to API’s and have been trying to do a POST request to get some timesheet data.  However, whatever code I try to use fails (it seems like the body/query is the main issue).  My latest attempt is below and it’s giving me an error on “StartDate”.  Are you able to help before I consider changing careers!

     

    let

    url = "myurl ",

    auth_key = GetAccessToken,

    header= [#"Authorization" = auth_key,

    #"Content-Type" = "application/json; charset=utf-8"],

     

    query = [

        ""StartDate"":""2022-10-31T00:00:00"",

        ""EndDate"":""2022-11-10T00:00:00"",

        ""fields"":""[Date, Status, CompanyName, CompanyReference, ApproverName, EntryQuantity]"",

        ""TimesheetStatusFilters"":""[Approved, Exported]""

    ],

     

    webdata = Web.Contents(url, [Headers=header,Query = query]),

    response = Json.Document(webdata)

     

    in

     

    response

     

    Many thanks