topic Re: POST Nprinting Body Parameters in Qlik NPrinting

POST Nprinting Body Parameters

aaron_ppmc — Wed, 25 Sep 2019 18:40:54 GMT

Hello Community,

I want to add Roles to a user in Nprinting via Rest API

Can Somebody tell me the parameters in the BODY, which i have to add.

QVX_UNEXPECTED_END_OF_DATA: HTTP protocol error 400 (Bad Request):

{"error":{"code":400,"message":"Malformed parameters in body"}}

Post:

SQL SELECT

"__KEY_data"

FROM JSON (wrap off) "data" PK "__KEY_data"

WITH CONNECTION( URL "XXXXXXXXXXXX", BODY "????????????????????????",

HTTPHEADER "Origin" "XXXXXXXXXXXXXX",

HTTPHEADER "Content-Type" "application/json",

HTTPHEADER "X-HTTP-Method-Override" "PUT",

HTTPHEADER "cookie" "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX; ")

Is there a general way to find the parameters for the bodies? Because I need this also for filters and groups for a user.

Thank you in advance

Aaron

Re: POST Nprinting Body Parameters

blaise — Mon, 07 May 2018 22:46:14 GMT

Hi Aaron

Have you solved this? I'm struggling with a similar issue

Re: POST Nprinting Body Parameters

blaise — Tue, 08 May 2018 07:13:47 GMT

The API doc list "roleIds" as the required request body string - https://help.qlik.com/en-US/nprinting/February2018/APIs/NP+API/index.html#usersIdRolesPut

I've tried a lot of combinations like the following for a similiar NP API endpoint (PUT /users/{id}/groups);

{"groupIds"."guid1"}

without any luck

Re: POST Nprinting Body Parameters

aaron_ppmc — Tue, 08 May 2018 09:01:51 GMT

Hy Johan,

i have not solve it - it still doesn't work

Re: POST Nprinting Body Parameters

blaise — Tue, 08 May 2018 09:14:45 GMT

Well i begin to think that the API isn't production ready yet, or at least poorly documented.

I will open up a support case tomorrow if I'm not able to solve it before then.

Re: POST Nprinting Body Parameters

aaron_ppmc — Tue, 08 May 2018 09:22:43 GMT

will you post the answer of qlik or your solution ?

Re: POST Nprinting Body Parameters

blaise — Tue, 08 May 2018 09:25:08 GMT

of course

Re: POST Nprinting Body Parameters

blaise — Tue, 08 May 2018 13:01:59 GMT

Hi agan Aaron

I just solved my issue with Users/{id}/Groups with the following format for request body;

["my_group_guid"]

Re: POST Nprinting Body Parameters

blaise — Tue, 08 May 2018 13:06:23 GMT

I've tried the /Roles endpoint on my env. and it worked good with the request body above

Re: POST Nprinting Body Parameters

aaron_ppmc — Tue, 08 May 2018 13:39:45 GMT

thanks a lot Johan! it also work for me!

Re: POST Nprinting Body Parameters

zepper00 — Mon, 02 Jul 2018 01:01:21 GMT

Hi Johan,

I do as you said in the script but there still is one error.

________________________________________________________________________________________

set vUserBody = '{"id":"$(vUserId)","my_group_guid":"6e026b28-58e8-4cbc-b906-30c0050491c4"}';

let vUserBody = replace(vUserBody,'"', chr(34)&chr(34));

let vPostUserULR = 'https://k70svqlikprod:4993/api/v1/users/'&'$(vUserId)/groups';

RestNPPOSTandPUTTestTable:

SQL SELECT

"__KEY_data"

FROM JSON (wrap off) "data" PK "__KEY_data"

WITH CONNECTION( URL "$(vPostUserULR)", BODY "$(vUserBody)",

HTTPHEADER "Origin" "XXXXXXXXXXXXXXXXXXXXXXXXXXX",

HTTPHEADER "Content-Type" "application/json",

HTTPHEADER "X-HTTP-Method-Override" "PUT",

HTTPHEADER "cookie" "$(vCookie)");

[post_and_put_items]:

LOAD [__KEY_data] AS [__KEY_data]

RESIDENT RestNPPOSTandPUTTestTable

WHERE NOT IsNull([__KEY_data]);

DROP TABLE RestNPPOSTandPUTTestTable;

_________________________________________________________________________________________

Is there any mistakes, could you please help show me. thanks in advance.

Re: POST Nprinting Body Parameters

mneidlinger — Wed, 07 Nov 2018 14:50:00 GMT

Johan,

I am still struggling with getting this to work. Is this what you meant?

set vUserGroupBody ='["b5a236e9-b8de-4a74-b92d-000ed15d0ae9","19e6feb1-58ff-412e-bb02-bc0a9c114f8d"]';

let vUserGroupBody = replace(vUserGroupBody,'"', chr(34)&chr(34));

...

WITH CONNECTION( URL "$(vPutUserGroupURL)", BODY "$(vUserGroupBody)",

...

I can get it to work in Postman but when I run it in Qlikview I get the following error.

{"error":{"code":400,"message":"Malformed parameters in body"}}

Thanks

Re: POST Nprinting Body Parameters

JonnyPoole — Wed, 05 Dec 2018 17:26:31 GMT

i just got this to work too by updating an existing user's security role .

Try it on an NPrinting user that isn't an administrator. When you work with administrators, it won't work unless you include the administrator roleID in the body as well.

otherwise it looks good.

please show a screenshot of the full error if you can ... need to see every parameter in there and what its resolving too in your environment

Re: POST Nprinting Body Parameters

SaiPranathiG — Thu, 10 Feb 2022 07:49:40 GMT

Hi Blaise

Can you provide the full syntax.

iam using only user

TIA

Re: POST Nprinting Body Parameters

Lech_Miszkiewicz — Thu, 10 Feb 2022 12:16:58 GMT

@SaiPranathiG

The whole lot you can find here:

https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

Re: POST Nprinting Body Parameters

SaiPranathiG — Fri, 11 Feb 2022 05:22:01 GMT

Can you provide me the sample code for this?