Instructions on how to use the Wolfram Cloud Test button are found in the Set Preferences in Excel section. Running the cloud test should give the following dialog if run successfully.
If this error is shown, all other tests will fail as a consequence. There was no server found at the URL given for the Cloud Base. Please make sure that you are connected to the internet and that the Cloud Base is set correctly. See the Preferences section for more details.
If this error is shown, a Wolfram Cloud is not found at the Cloud Base. Please make sure that the Cloud Base is set correctly. See the Preferences section for more details.
If this error is shown, a secure HTTPS connection cannot be made to the Wolfram Cloud. By default, the Wolfram Cloud requires a valid certificate to be installed on your system. However, you can disable this requirement with the Verify Security Certificates preference setting. See the Preferences section for more details.
If this error is shown, the Wolfram Cloud you are connecting to does not have the documentation account correctly installed. Instructions for installation are found in Setup and Getting Started > Setup for Administrators.
The section outlines common errors you might see when using the WolframAPI and Wolfram functions in Excel. It provides likely reasons for these errors and how to resolve the issues. This section is intended to be used by both Excel users and developers.
To check that the Wolfram API exists, use the Copy URL button to copy the URL to the clipboard. Enter this into a web browser and check for a response. If the API does not exist, you will get a 404 page.
Please verify that the API name is correct. See the API Name documentation for details.
If you are the owner of the API, you can check the reason by copying the URL with the Copy URL button. Paste the URL into a web browser, where you should be redirected to a sign-in page. When you sign in, if the API does not exist, you will get a 404 page. If the permissions need correcting, information can be found at Writing Wolfram APIs > Permissions.
If you see this message, the Wolfram API is working correctly, but the data needs to expand to fill other cells that have data in them. Clicking the Go to button will reveal the API's target area. Remove any preexisting data from the target area and rerun the Wolfram API for correct expansion.
A WolframAPI typically has Parameters that are added to the Excel formula. If there is an issue regarding these parameters, you will receive errors accordingly. There are two types of errors that can be given.
Parameter "parameter name" is required
Parameter "parameter name" cannot be interpreted from the input
If you see this message, the parameter was included in the WolframAPI call, but its value was not of the correct type. Clicking the More Info button will give its Interpreter type. Every Parameter has an Interpreter type, defining the type of data that it will accept. The following error outlines the type "Number", which must be a number.
It can be difficult to understand these Interpreter types if you are not a Wolfram Language developer. The owner of the API should be able to give you more information on what kind of data the parameter can take.
Check that the Wolfram tab is on the Excel Ribbon. If this is not visible, the CloudConnector plugin is not installed or has been disabled. If it has been disabled, you should be able go to the add-ins dialog and enable the plugin. If you cannot see any reference to the CloudConnector in the add-ins dialog, a reinstall of the plugin will be required.
If the Wolfram tab is visible but still does not work, check that the APIsEnabled icon is red. If the icon is gray, the WolframAPI function will not operate. The icon should look like the following for APIs to work.
If you see this message, the security certificates to the Wolfram Cloud cannot be verified. The most likely reason is that you are accessing a Wolfram Enterprise Private Cloud that does not have security certificates. You can bypass certification by unchecking the Verify Security Certificates value in the Preferences.
If you see this message, the Introspector API has not been deployed on the cloud account that hosts the Wolfram API you wish to call. Only this owner can fix the issue by deploying the Introspector API. Details are found in Setup > Deploying the Introspector API.
If you are using Wolfram APIs from the Examples page and connecting to an Enterprise Private Cloud, you may find the examples do not execute correctly. This is most likely because the documentation account has not been created. Your administrator will be able to install this account, using the instructions found at Setup and Getting Started > Setup for Administrators.