Cadet | Tier 2

Question

A360 ServiceNow Package - Where to enter "sysparm_fields"

Forum|Forum|3 years ago
September 21, 2022
4 replies
346 views

In the Command "ServiceNow: Get Multiple Records", we have the provision "Encoded Query String (i.e. sysparm_query) (optional)" to enter the sysparm_query. But I don't see any provision to enter the "sysparm_fields".

Is there any way to enter the sysparm_fields in the command ?

Note: I'm trying to get some field values (Variables) from a RITM. So, my value in the sysparm_fields will be like variables.first_name, variables.last_name, variables.department etc. to get the respective values.

The same Method in Postman would look like this:

postman

Navigator | Tier 3

You can use the sysparm query field to do so.

sys_id=$RITM_ID$&sysparm_fields=approval,$RITM_REQUESTER_TYPE_VARIABLE_ID_LIST[0]$,$RITM_REQUESTER_EMAIL_VARIABLE_ID$,u_approvers

ambarish.raoAuthor

Cadet | Tier 2

Hello @Sumit Kumar ,

Thank you for sharing the solution.

I have tried to do the same thing with my env, But I'm getting an error like "An unexpected error occurred. null"

Am I missing something here? Can you please guide.

SNOW_GetMultipleRecords Note:

1) I have tried using the actual sys_id instead of RITM1234567

2) Tried "Values to Return for Each Dictionary in List" option.

Still the same.

Navigator | Tier 3

@Ambarish Rao Please update the package.

Then you can use it like this:

ambarish.raoAuthor

Cadet | Tier 2

@Sumit Kumar - Thank you so much for alternative method. It worked :)