Forum Discussion

Robbe's avatar
Robbe
Regular Visitor
4 years ago

Web.Contents Call, not working

Hi all,

 

I'm trying to do an API call that should send the following Call : 

https://<<BASE-URL>>/rest/insight/1.0/iql/objects?objectSchemaId=3&iql=objectId=3

As documented here: Solved: Insight Rest API to query custom attributes (atlassian.com) 

 

I currently have the following : 

let
    FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
    let

        contents = Web.Contents(URL&"/rest/insight/1.0/iql/",[
            RelativePath  = "objects" ,
            Query = [
                        objectSchemaId = "3" , 
                        iql = objectId = "7249" , 
                        maxResults= Text.From(pageSize), 
                        startAt = Text.From(skipRows)]]),

        json = Json.Document(contents),
        Value = json[issues],
        table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
    in
        table meta [skipRows = skipRows + pageSize, total = 500]
in
    FetchPage

 

The main issue I think is the fact that the line  "iql = objectId = "7249" has a double "=". 
Any Idea how I should fix my Call ? 

 

Robbe

Need Help

5 Replies

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Robbe ,
    if a nested record is required here, you could try the following:

     iql = [objectId = "7249"] ,

     

  • Robbe's avatar
    Robbe
    Regular Visitor
    4 years ago

    Hi ImkeF , 

    Thank you for your reply! 
    I indeed tried that aswell, but I got the following error :

     

    let
    FetchPage = (url as text, pageSize as number, skipRows as number) as table =>
    let

        contents = Web.Contents(URL&"/rest/insight/1.0/iql/",[
            RelativePath  = "objects" ,
            Query = [
                        objectSchemaId = "3" , 
                        iql = [objectId = "7249"],
                        maxResults= Text.From(pageSize), 
                        startAt = Text.From(skipRows)]]),

        json = Json.Document(contents),
        Value = json[issues],
        table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
    in
        table meta [skipRows = skipRows + pageSize, total = 500]
in
    FetchPage

     

     

    Any ideas? 

     

    Robbe

  • Robbe's avatar
    Robbe
    Regular Visitor
    4 years ago

    ImkeF , 
    Also when trying to add it hardcoded, it auto converts the "=". 

    how do I get this trough ? 

     

    Robbe

     

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Robbe ,
    how did you write it?:
    so: "iql=[objectId=7249]"

    or so: "iql=[objectId=""7249""]"

    • Robbe's avatar
      Robbe
      Regular Visitor
      4 years ago

      Hi, 
      As soon as I put the "=" between quotations it switches the "=" to "%5B"

       

      The other suggestions you gave : 

       

      Resulted still into this: 
      Are you sure the nested Queries work ? 

       

      Robbe