Forum Discussion

AnjaW's avatar
AnjaW
Helper I
5 years ago
Solved

connecting to iSAMS via Batch API in Advanced Editor

I am getting a "token comma exprected" error message - position in color. Could it be a misplaced bracket? Thanks a million.

 

 

let

Source = Xml.Tables(Web.Contents(“https://isams-XXXXXXXXX”, Headers=[#"Content-Type"="application/xml"],

Content=Text.ToBinary("

<Filters>

<SchoolReports>

<Records IDsToInclude="3750" />

<ReportCycles ReportTerm="1" ReportCycleType="0" ReportYear="2020,2021" />

</SchoolReports>

</Filters>

")
]))

in

Source

 

Need Help

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Looks like you are missing the [ in front of Headers.

    Pat

     

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi AnjaW ,

     

    Please check if this works:

     

     

    let

    Source = Xml.Tables(Web.Contents("https://isams-XXXXXXXXX", [Headers=[#"Content-Type"="application/xml"],

    Content=Text.ToBinary("

    <Filters>

    <SchoolReports>

    <Records IDsToInclude=""3750"" />

    <ReportCycles ReportTerm=""1"" ReportCycleType=""0"" ReportYear=""2020,2021"" />

    </SchoolReports>

    </Filters>

    ")
    ]))

    in

    Source

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.