Web.Contents Call, not working

[Robbe]

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

[ImkeF]

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

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

[Robbe]

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

[Robbe]

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

how do I get this trough ? 

Robbe

[Robbe]

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

[ImkeF]

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

 iql = [objectId = "7249"] ,