question Re: REST API Issue for service-now catalog in Developer forum

REST API Issue for service-now catalog

adityamadhira — Mon, 06 Mar 2017 18:56:06 GMT

Hi I am planning to use REST API for service catalog in C# and facing below issue while testing. Please help me to fix this issue -

To test I navigated to "REST API Explorer" in service now. While testing Add Item To Cart (POST) call fails. Please refer attached screen short.

Error -

{
"error": {
"detail": "",
"message": "Invalid Quantity value"
},
"status": "failure"
}

Please help me what the issue is?

Re: REST API Issue for service-now catalog

fredflintstone — Mon, 06 Mar 2017 19:12:30 GMT

It's a bit difficult to see your screenshot, but it looks like in the body 'quantity' is misspelled. It appears you're setting 'quantitiy' (extra i before the y)

Re: REST API Issue for service-now catalog

karthik73 — Mon, 06 Mar 2017 19:12:49 GMT

Hi Aditya,

I don't think you can use quantity in cart, as the field is on the cart item table.

Re: REST API Issue for service-now catalog

karthik73 — Mon, 06 Mar 2017 19:22:52 GMT

Hi Aditya,

The parameter for quantity is sysparm_quantity, Service Catalog API - POST /sn_sc/servicecatalog/cart/{cart_item_id} . And i am able to update the quantity on the cart item by setting sysparm_quantity

Re: REST API Issue for service-now catalog

adityamadhira — Mon, 06 Mar 2017 21:16:49 GMT

I am seeing below error , after adding syspam_quantity

{
"error": {
"detail": "",
"message": "Security constraints prevent ordering of Item"
},
"status": "failure"
}

Re: REST API Issue for service-now catalog

adityamadhira — Mon, 06 Mar 2017 21:17:22 GMT

Re: REST API Issue for service-now catalog

karthik73 — Mon, 06 Mar 2017 21:35:21 GMT

Hi Aditya, Which sys_id are you providing in the request?

You have to provide the sys id of the catalog item

Re: REST API Issue for service-now catalog

karthik73 — Mon, 06 Mar 2017 21:39:51 GMT

Also please ensure you have access to the catalog item

Re: REST API Issue for service-now catalog

adityamadhira — Mon, 06 Mar 2017 21:39:51 GMT

Provided below item sysid.

Re: REST API Issue for service-now catalog

karthik73 — Mon, 06 Mar 2017 21:56:14 GMT

Are you aware of any security constraints on the item? Have you tried sending the request as a different user?

Re: REST API Issue for service-now catalog

adityamadhira — Mon, 06 Mar 2017 22:12:38 GMT

I trying with user that admin,catalog & catalog_admin & security_admin roles. Do I miss any info

Re: REST API Issue for service-now catalog

Jaspal Singh — Mon, 12 Jun 2017 13:12:55 GMT

Hi Aditya,

Did you get any solution to this issue of invalid quantity?

Thanks,

Jaspal Singh

Re: REST API Issue for service-now catalog

Jaspal Singh — Wed, 21 Jun 2017 10:06:20 GMT

Hi Aditya,

Did you get it worked or you weren't able to?

Thanks,

Jaspal Singh

Re: REST API Issue for service-now catalog

esr124 — Tue, 12 Sep 2017 15:24:01 GMT

Did you ever get this error resolved? I'm having the same issue. Adding a catalog item to the cart with the API getting the same error. When I set the sysparm_quantity value to 1 I get the same error.

Re: REST API Issue for service-now catalog

Jaspal Singh — Tue, 12 Sep 2017 15:48:22 GMT

Hi Eric,

Try passing in header as below

Re: REST API Issue for service-now catalog

tony_barratt — Tue, 12 Sep 2017 16:33:54 GMT

Hi Eric,

curl "https://instance_name.service-now.com/api/sn_sc/servicecatalog/items/04b7e94b4f7b4200086eeed18110c7fd/add_to_cart" \

--request POST \

--header "Accept:application/json" \

--header "Content-Type:application/json" \

--data "{\"sysparm_quantity\":\"1\"}" \

--user 'admin':'admin'

gave this response:

{
"result": {
"cart_id": "ad08fe9413b04b00125ad8228144b0bc",
"subtotal": "$1,100.00",
"items": [
{
"catalog_item_id": "04b7e94b4f7b4200086eeed18110c7fd",
"quantity": "1",
"localized_price": "$1,100.00",
"price": "$1,100.00",
"recurring_frequency": "Annually",
"localized_recurring_price": "$100.00",
"recurring_price": "$100.00",
"item_name": "Standard Laptop",
"cart_item_id": "40838c6713894300125ad8228144b0e0"
}
]

Re: REST API Issue for service-now catalog

tony_barratt — Tue, 12 Sep 2017 16:35:15 GMT

Re: REST API Issue for service-now catalog

esr124 — Thu, 14 Sep 2017 17:22:44 GMT

Using the REST API Explorer withing ServiceNow I was able to get the sysparm_quantity variable to be passed, but now it's giving me another error:

Mandatory Variables are required

I looked at the catalog item. When I go to that catalog item's form and right-click and select Configure variables, there is only one variable listed: service_offering.

Re: REST API Issue for service-now catalog

tony_barratt — Thu, 14 Sep 2017 17:39:18 GMT

Hi Eric,

Could you generate the curl code from the REST api explorer and post it - along the lines of my post Sept 12?

There may be some clues there!

Re: REST API Issue for service-now catalog

esr124 — Thu, 14 Sep 2017 17:50:07 GMT

I looked at the variables and it looks like that service_offering is the only mandatory variable.

I just don't know how to add the service_offering variable to the variables.

I get a 400 Bad Request "Mandatory Variables are required".

Below is the Request body with my 2 elements:

{"sysparm_quantity":"1","variables":"{\"service_offering\":\"56aedfba0ff1b100f178317ce1050e2e\"}"}

I think the problem is the variables element, it must not be formatted correctly, that's the only thing I can think of.