How to query servicenow tickets using its API (powershell)

[Matt Campbell1]

Hello, I'm playing around with the SNOW API. 

I'm trying to figure a method to query for task numbers from this table sc_task.

Hoping to get some help with this.

Currently on Jakarta for SNOW

$uri = "https://xxxxxxx.service-now.com/api/now/table/sc_task? 

This my URL i'm using but i'm not sure what to add at the end of this URI to query a specific task number.

Thanks,

Matt

[Matt Campbell1]

Getting further, seems our proxy is blocking something causing the output to be wonky. 

But i'll play around with it more. 

[Matt Campbell1]

Having %D seems to come back with a null results. 

I tried running like this

https://xxxxxxx.service-now.com/service-now.com/api/now/table/sc_task?sysparm_query=number'0065475'"

but it was querying massive amounts of data(I stopped it), I think it was getting all the tickets within our SNOW system. 

Guessing I did something wrong.  Maybe this type of query isn't available in Jakarta ?

[SanjivMeher · Accepted solution]

Ok..Do thhis

https://xxxxxxx.service-now.com/api/now/table/sc_task?sysparm_query=number=<Task Number>

The task number should be in format TASK0001231

For ex, I used

https://xxxxxxx.service-now.com/api/now/table/sc_task?sysparm_query=number=TASK0000001

[Matt Campbell1]

Genius! I had single quotes around the task which broke it. 

Thanks for the help! I may have more question but i'll create a new thread for that.

[sachin_namjoshi]

You can always use OOB REST API explorer which is inbuild and provides code examples for powershell too.