<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- Setting an Access Level on a Report</strong></p><p><strong>- Setting Up Excel</strong></p><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">Setting an Access Level on a Report</span></strong></p><p>We first need to gather the API link to access the report. This can then be concatenated onto your URL. </p><p><br></p><p>The API extension on your report can be found within the Availability tab, once you have published it. </p><p><br></p><p>There are two Access levels you can choose from. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImRjZWFiOTNhLTZlNzUtNDhkOC04MjQ1LTNkMWM5OGMzZDM1NyJ9.XbbSJYN4AtPo051Ei1dqv7bLJRgtPOyDrx6_a4N5fF0" class="fr-fic fr-fil fr-dib" width="616" style="width: 618px; height: 716.095px;" height="716"></p><p><strong><span style="font-size: 10pt;">Fig 1. Setting Access Level on a report</span></strong></p><p><br></p><p><strong>Allow Anonymous Access</strong> - This will allow anyone who has this link to be able to access this report.</p><p><strong>Use Publish Profiles </strong>- This will let you set a password when you are importing this into Excel.</p><p><br></p><p>When Using Allow Anonymous, you will receive an API link below:</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjFhNDE4MTAwLWU4ZDItNDIwNy05OGMyLWI3YTUyZTQ3MzYwMyJ9.7nzMhjd1nKLjIG570eNw8xaj6ukLCx01XCcEBhlYDHc" class="fr-fic fr-fil fr-dib" width="699" style="width: 701px; height: 269.717px;" height="270"></p><p><strong><span style="font-size: 10pt;">Fig 2. Report access URL after setting Allow Anonymous Access</span></strong></p><p><br></p><p>You will add this onto the end of your Halo URL, e.g. https://halopsa.test/api/ReportData/997...This will be used later.</p><p><br></p><p><strong><span style="font-size: 14pt;">Setting Up Excel</span></strong></p><p>When you have a new Excel page, use the "From Web" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjM1NTJkYTJmLTJkYTItNDA0My1hY2M1LWZjODEwYWZiODJkZSJ9.-7JviAXGMeG5ratqzgh-u2nlQaRYbZ2C7FlsYoAfVqM" class="fr-fic fr-fil fr-dib" width="544" style="width: 546px; height: 685.657px;" height="686"></p><p><strong><span style="font-size: 10pt;">Fig 3. From Web button in Excel</span></strong></p><p><br></p><p>Then copy your link you saved from before and click "OK":</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijk5MGE4YTExLTdlODktNDMyYy04Mjk4LWI0NGU4MjlhYjBiYiJ9.qM-WcoxmC9MZJHzoqwq4JnEVpW7mvcJ_XI3NDye4NBA" class="fr-fic fr-fil fr-dib" width="940" style="width: 942px; height: 303.203px;" height="303"></p><p><strong><span style="font-size: 10pt;">Fig 4. Adding the URL into the From Web area</span></strong></p><p><br></p><p>When on this page click "Connect".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImZiNDYzMTgwLTIwYzItNDM5Ni1iOWNmLWQ5NzdmNDQ0ZDhmMiJ9.s7rZZIYkJ552yo9MgxPUT4tKE3Zmw9u-50htlQa-VEs" class="fr-fic fr-fil fr-dib" width="809" style="width: 811px; height: 328.097px;" height="328"></p><p><strong><span style="font-size: 10pt;">Fig 5. Connecting with the Anonymous tab in Excel</span></strong></p><p><br></p><p>When the data has loaded, you will come to this page where you will right-click on the column header "List" and choose "To Table" or you can use the same button in the top left corner.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZkZmEwNDJlLTk3MTktNGYxMy05MzVlLWY2YTBlZTQ1N2NjNiJ9.m0vvA7I39LAKPSoS2bvHlgC68mHCuu5DYaQZwAMMmN0" class="fr-fic fr-fil fr-dib" width="969" style="width: 971px; height: 312.903px;" height="313"></p><p><strong><span style="font-size: 10pt;">Fig 6. Selecting To Table in Excel</span></strong></p><p><br></p><p>For this page, you will not need to change anything and click "OK".</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjY3NGRiMDkzLTgzNGMtNGM5NS1hZWM2LTE1ZGQyNzY5MTI4ZSJ9.qEkfBhttFnQbuEuEXhjEixZ1Lt8kHd-jUozDPTznnRE" class="fr-fic fr-fil fr-dib" width="973" style="width: 975px; height: 376.641px;" height="377"></p><p><strong><span style="font-size: 10pt;">Fig 7. To Table settings in Excel</span></strong></p><p><br></p><p>On this page you left click the box highlighted below and filter the columns you would like to display:</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImEzZGNjNDY5LWYxZDAtNGM1Ni05ZmVlLWJjY2E0MTUzYTZlZiJ9.n19YIPdZxPAFYp9pMPnAl9OANZAY92WspmzgkGhLsgM" class="fr-fic fr-fil fr-dib" width="975" style="width: 977px; height: 474.036px;" height="474"></p><p><strong><span style="font-size: 10pt;">Fig 8. Filtering columns in Excel</span></strong></p><p><br></p><p>From this page, you will want to rename your headers and set the data type for each of your columns accordingly. If you change them on the excel spreadsheet, when you refresh the data, the column headers will be over written. You can then "Close and Load" in the top left and your report from Halo will now be displayed in your Excel spreadsheet.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE4MzhjMGQxLTJlNWEtNDgzZi04ZTU4LTRkYTUzNTc3OTNkZiJ9.tnrzNhPlteYufaSXJ6bekz15YddNs1GSzEaWsh_m22w" class="fr-fic fr-fil fr-dib" width="975" style="width: 977px; height: 463.566px;" height="464"></p><p><strong><span style="font-size: 10pt;">Fig 9. Changing the column names in Excel</span></strong></p><p><br></p><p>If you ever need to edit the column Headers or data format, to get back to your queries please go to "Data" and "Queries and Connections", then the queries related to the different tables you have imported will be on the right side.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE0YmI2YTg0LTMyZjgtNGNiNy1iMDEwLTQ4NDhhNDIyYWIyNSJ9.5dunqCG3_jiLtOMlN21QjDoKVBKidPEvfBMi4-6S_XI" class="fr-fic fr-fil fr-dib" width="974" style="width: 976px; height: 297.389px;" height="297"></p><p><strong><span style="font-size: 10pt;">Fig 10. Editing the column headers or data format in Excel</span></strong></p><p><br></p><p>If you would like to set up a more secure log in, you can set up the "Publish Profiles" On the Access Level. </p><p>You would need to start on a new excel spreadsheet. You can select the publish Profile that you would like to have access to this report:</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijg2NTIzZGMwLTk3NDMtNGRiNi1hNTc5LWM3MzIyY2YwZmFjMyJ9.tb9Hb9vuCWWjmECFL1WDyjnDtKJKKhAdcE0HnIwhCOQ" class="fr-fic fr-fil fr-dib" width="402" height="533"></p><p><strong><span style="font-size: 10pt;">Fig 11. Publish Profiles option in Halo</span></strong></p><p><br></p><p>Make sure the profile has access to the report on their profile in Configuration > Integrations > HaloPSA API > Publish Profiles.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjUxYjJmZWE4LTg0ZTItNDc5NS05ZDEzLTQwZmYwNzVhZTU0YyJ9.lIkguiiol-am7VYeX-YWQbWaMfKXaxJS5QHIjJTJEe0" class="fr-fic fr-fil fr-dib" width="414" height="280"></p><p><strong><span style="font-size: 10pt;">Fig 12. Setting report access in publish profiles configuration</span></strong></p><p><br></p><p>When you have imported the URL from before you will then get the authentication page when your will select the Basic section and input your publish profiles details.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjAwZmIxMTE2LTQyNDEtNDliMy04ODU3LTg2MjkyZmU5NGVmYyJ9.kTlSjY9szC5ucTH7Al3M5W9fDshBZ2buuR0VPGhLaKY" class="fr-fic fr-fil fr-dib" width="835" style="width: 837px; height: 443.96px;" height="444"></p><p><strong><span style="font-size: 10pt;">Fig 13. Basic tab in Excel for Publish profiles option</span></strong></p><p><br></p><p>This will then allow you access to the reports we had before.</p>
