Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..
256 views

Searching Operator records by contact IDs gathered in excel spreadsheet

Jump to solution

Hello,

I have compiled an excel spreadsheet with around 2000 contact ids, is there any way I can use that spreadsheet to pull up those user's operator records?

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Searching Operator records by contact IDs gathered in excel spreadsheet

Jump to solution

Short answer: yes, everything is possible.

Longer answer: that depends.  If you're a user who is set up with the Expert Search function that allows you to enter in a query, you can take your spreadsheet, turn it into a quoted comma separated list of values.  Like:

operator.id isin {"abcdef", "ghijkl", "mnopqr", "stuvwx"}

If you don't have access to the Expert Search, but you do have access to the REST or SOAP API, you could pass your search in that way.

If you have neither of those options, then no; there's not like a built-in function in Excel or Service Manager that lets you enter data into an Excel spreadsheet and HPSM interprets that data as a query. 

View solution in original post

0 Likes
1 Reply
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Searching Operator records by contact IDs gathered in excel spreadsheet

Jump to solution

Short answer: yes, everything is possible.

Longer answer: that depends.  If you're a user who is set up with the Expert Search function that allows you to enter in a query, you can take your spreadsheet, turn it into a quoted comma separated list of values.  Like:

operator.id isin {"abcdef", "ghijkl", "mnopqr", "stuvwx"}

If you don't have access to the Expert Search, but you do have access to the REST or SOAP API, you could pass your search in that way.

If you have neither of those options, then no; there's not like a built-in function in Excel or Service Manager that lets you enter data into an Excel spreadsheet and HPSM interprets that data as a query. 

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.