Highlighted
New Member.
452 views

How to export search result as .csv with API or maybe generated link

Hi. I want an automatically export in my google sheet. 
With e.G LeanKit there is an opportunity to build a link for export and generate a token with my user account.

Unfortunately I did not found anything similiar for HPSM. 

Is there an easy way to build an access with JavaScript/GoogleScript.

Or I had an export from Sharepoint with .iqy (internet query) which I used in excel.

Kind regards,

Kloso

0 Likes
2 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: How to export search result as .csv with API or maybe generated link

Hi Kloso,

On Service Manager, on my personal experience I haven't seen such functionallity than the usual, you can check the SM releases and verify if there is something similar as your requirement since I am not sure what version are you currently using. Just to remind you this is the normal csv export:

  1. Go to Window > Preferences, and make sure that the Client side load/unload option is selected.
  2. Open a list of records. For example, open a list of open incident records.

    Note:  You can use Modify Columns, so that only those columns containing data that you intend to export displays. You must keep the column that contains the key field.

  3. From the record list, click the More Actions icon, and choose Export to Excel.

  4. In the Filename field, specify a path and name for the file, and then click OK.

    Note: If you specify a file that does not exist, Service Manager will create it.

    HP Service Manager exports the record list to a CSV file and opens it in Excel.

Carlos Villalobos R
Customer Support Engineer
If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: How to export search result as .csv with API or maybe generated link

If I understand your question correctly, you'd like some sort of automated way to regularly get a .csv of SM data? You could schedule a ScriptLibrary function in SM which could write data to a .csv. You could also set up an external script which would reach into SM through the REST API, pull out the data, and write it to a .csv.

Those are just a couple ideas. It depends on what you need the data for. If you need to then iterate over it with some other script/tool, .csv might be best, yes, but you could also set up reports to occur automatically in the Reporting module of SM, if you are trying to provide reports/charts to your management/leadership.

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.