Working with XCalls

Xcalls allow users to reference content and data from spreadsheets on Coherent Spark from within Control files. These references are established in the spreadsheet prior to conversion to Control

Setting up XCalls

Set up the referenced Spark service before converting the workbook to Control. See Call Spark service APIs.

Recalculating Xcalls within a Controlled file

To calculate XCalls, select Recalculate XCall on the screen below.

Login for XCall - Using XCalls from different Spark environments

In some situations, users may need to reference data on different Spark environments (e.g. reference production vs non-production data). In this scenario, the "Login for Xcall" function allows users to login to this separate environment to execute the XCall and retrieve the relevant data.

To access this, please use the top-left menu inside the Control tab of the Coherent Assistant and click Login for Xcall.

The user can then log in to the appropriate Spark environment by typing in the relevant URL (via a pop-up). A brief message will appear once logged in.

Users are also able to see where they are logged in to for Xcalls by clicking the same menu.

Please note: Once a session is cancelled by closing the file or opening another control file, users will need to log-in to the xcall session again. This is done to prevent data being accidentally being used from the wrong environment (e.g. using non-production data).

Future enhancements will be made to establish more direct connections at the platform level.