Power-bi REST GET from ServiceNOW

[Anonymous]

Hello,

I am very new in creating REST get APIs, currently I have a working REST API script that gather data which resides within ServiceNOW environment. 

My question is: how to reference a REST API query using a "start with content" parameter?

example(see list below) - I would like to focus my REST API query based on task_numbers that begin with "INC" and not "CHG"

%2Ctask_number%^inc

Is this possible?

Thanks in advance.

Task_number

INC50391737

INC50390306

INC50388697

INC50381295

INC50373481

INC50372509

INC50371836

INC50352470

CHG50013255

CHG50013198

CHG50013187

CHG50013162

CHG50013145

CHG50013126

CHG50013120

CHG50013114

CHG50013098

[ams1]

Hi @Anonymous ,

Normally I'd ask you to please post a) a link to the relevand service now API documentation and b) the query you're using (after removing confidential information from it), but maybe we don't have to go there.

Please confirm my understanding:

For each item in that "Task_number" column that starts with INC you'd like to do what with it?

Example answers I'd expect are: pass it to a function (found in separate query) that calls the API to get data...

If that's the case, then maybe you could first filter that column to keep only items that start with INC.

P.S.: Seeing at least the query would help

[Anonymous]

Thanks for responding so quickly - my sole intention is to filter my initial REST GET query to return only task_numbers that begin with "INC" and not "CHG"