M query support

Question

Hi,I have problem with M query, as this part:&nbsp;Query=[jql= ( _ )], it causes the error because it need the " " to run the jql query like the sample:&nbsp;Query=[jql="project in ('Test') AND created &gt;= 2023-01-01"].Could you help me to put the " into the&nbsp;Query=[jql= ( _ )]?

jst_jdennis · Accepted Answer

To add the quotation marks to the Query=[jql=(_)] part of your M query, you can modify the "Added Custom" step to include the quotation marks in the URL string. Here's an example:&nbsp;// Now let's create a new column URL with the URL we are interested at. Note the maxResults and startAt parameters this time
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "URL", each "https://xxxxx.atlassian.net/rest/api/2/search?jql=" &amp; Uri.EscapeDataString("project in ('Test') AND created &gt;= 2023-01-01&amp;startAt=" &amp; Text.From([startAt])))&nbsp;In this example, we use the Uri.EscapeDataString function to encode the JQL query string, and add the quotation marks directly in the URL string. This should allow the query to run successfully.&nbsp;Credit: ChatGPT | https://chat.openai.com/chat&nbsp;

Forum Discussion

Related content

Campaign Voucher FAQ & Support

Community account support

merging direct query queries

Native SQL Query support

dax support - summ of grades