PowerShell Script Failing with Auth Header and 500 Internal Server Error for REST API

dandrevbarrio 

Hi, Drev.

Some of Oracle's documentation is locked behind a paywall while some is publicly accessible. I can only access the latter.

A quick search turned up the first article which points the reader to the second:

1. FDMEE REST APIs (oracle.com)
2. EPM Cloud REST API basic authentication for Classic and OCI (Gen 2) (oracle.com)

Where at the bottom of the second article is a PowerShell-based example on how to format the Authorization header.

Technically, it's not encrypted, only encoded, so the initial string values you'd be pass into the line via the $userName and $userPassword variables would be the actual plain text values for the relevant username and password.

But if what you're already doing matches the Oracle PowerShell example, then I'm unsure what else it might be, as the first article doesn't cover authentication at all.

The following URL may have more information, but it's locked away behind Oracle's paywall, so I'm simply guessing:

• FDMEE Script Samples (oracle.com)

Edited to add one final footnote:

When looking at the Oracle example, ensure you correctly use double-quotes and do not change them for single quotes, as the type of quotes used in PowerShell makes a big difference.

When parsing double-quoted strings, PowerShell will perform any variable substitutions and code executions.

Conversely, single-quoted strings are not parsed at all, where everything enclosed in the string is treated literally, i.e. there are no substitutions.

Cheers,

Lain