v3.1.2 - Fix adding attachments for pre-Istanbul instances

• Fix #160, adding an attachment to catalog tasks not working for instances created pre-Istanbul. Thanks @natescherer!

Fix #158, failure on successful record removal

• Fix #158, failure on successful record deletion
• Move table details retrieval in New-ServiceNowSession to be switch operated, -GetAllTable, and reduce function time
• Fix pipelining in Remove-ServiceNowRecord

Add DateTime support to querying

• Add DateTime support to querying, #68
• Add -between operator
• Enhanced value validation for all operators in New-ServiceNowQuery which is used by Get-ServiceNowRecord

v3.0.2 - Fix #152

• Fix #152, object conversion to json failing.

Fix #149 and #150

• Fix #149, combination of -Id and -IncludeCustomVariable failing. Thanks @natescherer.
• Fix #150, Test-ServiceNowURL does not account for URL with a - character. The validation wasn't providing much value so was removed.
• Getting info on all tables so we can be more intelligent/dynamic about prefixes. Querying the sys_number table and might require elevated rights. If rights aren't present, no failure will occur, this is just an added bonus for those with rights :)

v3 - Major release

Hi all. A lot of work went into this release and I hope it's useful. There are some breaking changes, but I've tried to keep them to a minimum as I move through some cleanup and consolidation. Please let me know if you find the new functionality helpful or any issues you might find given the number of changes.

• New functionality in Get-ServiceNowRecord
  • Add Id property to easily retrieve a record by either number or sysid.
  • Add ParentId property to easily retrieve records based on the parent number or sysid. For example, to retrieve catalog tasks associated with a requested item execute Get-ServiceNowRecord -Table 'Catalog Task' -ParentId RITM01234567.
  • Add Description property to retrieve records based on a table specific description field. For many tables this field will be short_description, but will be different for others. For example, when performing this against the 'User' table, the description field is 'Name'.
  • Add ability to provide a known prefixed Id without providing Table, Get-ServiceNowRecord -Id inc0010001. To see the list of known prefixes, execute $ServiceNowTable.NumberPrefix after importing the module.
  • Add alias gsnr. With the above change, a Get can be as simple as gsnr inc0010001.
• Add autocomplete for Table parameter in Add-ServiceNowAttachment and Get-ServiceNowAttachment.
• Add Id parameter to Add-ServiceNowAttachment and Update-ServiceNowRecord which accepts either number or sysid. Just as with Get-ServiceNowRecord you can now provide just Id if it has a known prefix.
• Add ability to Get-ServiceNowAttachment to get attachments either via associated record or directly from the attachments table when you want to search all attachments.
• Add advanced filtering and sorting functionality to Get-ServiceNowAttachment which can be really useful when searching across the attachments table.
• Convert access and refresh tokens in $ServiceNowSession from plain text to a credential for added security.
• Pipeline enhancements added in many places.
• Add Change Task and Attachments to formats.
• Update-ServiceNowNumber has been deprecated and the functionality has been added to Update-ServiceNowRecord. An alias has also been added so existing scripts do not break.
• Prep for removal of all Get- functions except for Get-ServiceNowRecord and Get-ServiceNowAttachment. Table specific Get functions have been deprecated. Get-ServiceNowRecordInterim has been created and all table specific Get functions have been aliased so existing scripts do not break. Please start to migrate to Get-ServiceNowRecord as these functions will all be deprecated in the near future.
• As communicated in v2.0, authentication cleanup has occurred. This involves removal of Credential/Url authentication in each function in favor of ServiceNowSession. You can still authenticate with Credential/Url, but must use New-ServiceNowSession. Set-ServiceNowAuth, Remove-ServiceNowAuth, and Test-ServiceNowAuthIsSet have been deprecated.
• Breaking change: rename Get-ServiceNowAttachmentDetail to Get-ServiceNowAttachment.
• Breaking change: rename Get-ServiceNowAttachment to Export-ServiceNowAttachment.
• Breaking change: Get-ServiceNowTable and Get-ServiceNowTableEntry have been deprecated. Use Get-ServiceNowRecord.

v2.4.2 - Add UseBasicParsing to avoid IE error on AA

• Fix #141, add UseBasicParsing to all API calls to keep AA from failing when IE hasn't been initialized

v2.4.1 - Get Custom Variables

• Add -IncludeCustomVariable to Get-ServiceNowRecord to retrieve custom variables, eg. ritm form values, in addition to the standard fields. #138

v2.4 - New CI

2.4

• Add New-ServiceNowConfigurationItem, #109
• Add grouping operators -and and -group as well as comparison operators -startwith and -endswith to Get-ServiceNowRecord -Filter to keep with the -operator standard
• Add tab ahead/completion for the -Table property in Get-ServiceNowRecord. This will allow you to cycle through the different tables the module is aware of. The values are the 'common' names, not table names so it's easier to understand for beginners. You can also provide any other table name ad hoc.
• Add Change Task to formatter and tab ahead
• Fix null index error when executing New-ServiceNowQuery without providing a value for -Sort
• Fix #136 to account for PS v7.x Invoke-WebRequest response headers all being arrays

2.3.2

• Added ability to pipe to Add-ServiceNowAttachment and Get-ServiceNowAttachmentDetail. For example, New-ServiceNowIncident @params -PassThru | Add-ServiceNowAttachment -File MyFile.txt. This will create an incident and add an attachment in one step.

2.3.1

• Fix query operator -notin and -notlike which had a missing space
• Move verbose logging message in Invoke-ServiceNowRestMethod for number of records so it always shows. This is helpful when you change a filter and can see how many records would be returned without actually returning them.

v2.3 - Paging support

• Add paging support to all Get- functions. Use -First, -Skip, and -IncludeTotalCount parameters. In support of this, api calls have been changed from Invoke-RestMethod to Invoke-WebRequest.
• Additional pipline support added for Table and SysId parameters to pipe Get- functions to Update- and Remove-.
• Breaking change: deprecate -Limit parameter. The warning regarding deprecation went out over 2 years ago and now that paging has been implemented, it's a good time for this cleanup. Use -First instead.
• 'TableEntry' renamed to 'Record' for New-, Update-, and Remove- functions. Aliases added.