connecting to iSAMS via Batch API in Advanced Editor

[AnjaW]

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

[Ahamed]

this is not working for me !!  

[Icey]

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.

[mahoneypat · Accepted solution]

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

Pat