Explicitly state fields in API post statement

[Anonymous]

Hi,

I'm hoping someone can help explicitely state what fields to bring in via my API connection.

As things stand it brings through most, but not all available fields; and included in those that are not being brought over are some important ones that are needed for the subsiquent MI.

= Table.AddColumn(#"Removed Other Columns", "Custom", each Json.Document(VSTS.Contents("https://dev.azure.com/companyenvironment/_apis/wit/workitemsbatch?api-version=7.1-preview.1",

[Headers = [#"Content-Type"="application/json"],
Content = Json.FromValue([ids=_[Grouped IDs]])

])))

Thanks in advance.

[artemus]

What you are missing is probably the response headers. You can get this by using Value.Metadata on the results of VSTS.Contents. For example:

= Table.AddColumn(#"Removed Other Columns", "Custom", each let ado = Json.Document( VSTS.Contents("https://dev.azure.com/companyenvironment/_apis/wit/workitemsbatch?api-version=7.1-preview.1",

[Headers = [#"Content-Type"="application/json"],
Content = Json.FromValue([ids=_[Grouped IDs]]))

])) in [Data = ado, Headers = Value.Metadata(ado)])