How do I use the Luminesce CLI?

The Luminesce CLI runs queries either:

At the command line or from files, in which case results can be returned in CSV, Excel or SQLite formats.
Using interactive mode, in which case results can be printed.

See all tools and interfaces to Luminesce.

Installing the CLI

Make sure your computer has .NET 6 installed.
As a LUSID user with the lusid-administrator role, navigate to <your-domain>.lusid.com/honeycomb/swagger/index.html, where <your-domain> is the root of your LUSID domain, for example acmecorp. If you do not have the lusid-administrator role, see the appendix.
Use Swagger's Try it out button for the DownloadBinary API to request the CommandLineTool binary:
Click the Download file link in the response to download the binary to your browser's download location:
Navigate to the download and run the following command, omitting the .nupkg file extension and, on Mac, using the x64 version of dotnet:
```
C:\Users\JohnDoe\Download> dotnet tool install Finbourne.Luminesce.Cli -g --add-source "."
```
Note that the CLI is installed in the following location:
- Windows: %USERPROFILE%\.dotnet\tools\.store\
- Linux/MacOS: $HOME/.dotnet/tools/.store/
Run the following command to start the service, omitting the .exe extension on Linux or MacOS:
```
C:\Users\JohnDoe\.dotnet\tools> luminesce-cli.exe --quiet --authClientDomain=<your-domain> --certificateFallback=DownloadMayMint
```
...where <your-domain> is the root of your LUSID domain, for example --authClientDomain=acmecorp. Note the DownloadMayMint option mints a new certificate if you do not have one already; more information on managing certificates is coming soon.
Note: For information on all the command line options, run the command luminesce-cli.exe --help.

The CLI starts in interactive mode, so you can write a query like this and press CTRL-ENTER to run it:

To uninstall the package, perhaps in order to upgrade to a newer version, run the command dotnet tool uninstall Finbourne.Luminesce.Cli -g.

Appendix A: Allowing non-administrative users to downloading binaries

Once a license is granted, users with the lusid-administrator role have permission to download the CommandLineTool binary out-of-the-box.

To enable less privileged users to download, create a feature policy consisting of the following JSON, assign it to a role, and the role to their LUSID user:

{
    "description": "User can download CLI binary",
    "applications": [
        "Honeycomb"
    ],
    "grant": "Allow",
    "selectors": [
        {
            "idSelectorDefinition": {
                "identifier": {
                    "code": "CommandLineTool",
                    "scope": "Honeycomb"
                },
                "actions": [
                    {
                        "scope": "Honeycomb",
                        "activity": "DownloadBinary",
                        "entity": "Feature"
                    }
                ],
                "name": "Command line tool binary",
                "description": "User can download CLI binary"
            }
        }
    ],
    "when": {
        "activate": "2023-01-01T00:00:00.0000000+00:00",
        "deactivate": "9999-12-31T23:59:59.9999999+00:00"
    }
}