KKR to Acquire Ness Digital Engineering

October 27, 2022 – KKR, a leading global investment firm, today announced the signing of definitive agreements under which KKR will acquire 100% of Ness Digital Engineering (“Ness” or the “Company”), a global full-lifecycle digital services transformation company, from The Rohatyn Group (“TRG”).

Founded in 1998 and headquartered in Teaneck, New Jersey, Ness is a leading provider of end-to-end digital transformation services that specializes in building digital software products and platforms. Ness helps organizations envision, build, and continually evolve their digital platforms to enter new markets, capture new revenue, and gain operational efficiencies. The Company offers a wide range of digital practices that include cloud engineering, data and analytics, experience design, intelligence engineering, and salesforce for businesses across sectors. Today, Ness has a presence in North America, Europe, the Middle East, and Asia, with a globally diversified talent pool across India, Eastern Europe, and the United States.

Gaurav Trehan, Partner and CEO of KKR India, said, “Digital transformation and adoption is a critical strategy for businesses of all sizes worldwide. Against this backdrop, KKR believes that Ness is well-positioned for growth, supported by its exceptional, experience-led product engineering heritage. KKR is pleased to invest in Ness’ capabilities and looks forward to working alongside its talented team to further scale Ness’ digital-first platform, achieve its global ambitions, and better enable its customers to compete in the digital economy.”

Ranjit Tinaikar, CEO of Ness, said, “We are thrilled to welcome an investor of KKR’s caliber in Ness. We believe this transaction will help us turbocharge our growth plans and further strengthen our competitive market position. We look forward to leveraging KKR’s global platform and strong investment and operational expertise to deliver more innovative solutions to help our customers keep up with the pace of digitalization required by the accelerated online economy. I want to thank TRG for their consistent stewardship throughout the years. They have been great strategic partners to the management team and helped us to execute our growth strategy.”

Nicolas Rohatyn, chief executive officer and founder of The Rohatyn Group, said, “We are proud to have tapped into TRG’s technology services expertise and extensive global experience to help Ness become a unique, global leader in the digital space. We wish the Company the best in its next chapter.” Tom Kucera, Managing Director at TRG, added “I am grateful to Ranjit, the management team and Ness’ more than 4,000 employees for their partnership, dedication and support over the years. It has been a privilege working closely with them to build Ness into a premier digital transformation platform and I wish them continued success.”

Ness adds to KKR’s global portfolio of technology investments, which includes, but is not limited to, Cloudera, a leading provider of enterprise-grade, hybrid data management software in the United States; Yayoi, a software developer, distributor, and support service provider for small-and-medium-sized enterprises in Japan; Probe CX, a provider of outsourced customer experience and business process outsourcing solutions in Australia; MYOB, a leading Australian online business management company; and Jio, a next-generation technology platform that provides digital services across India.

KKR makes its investment from its Asian Fund IV. Additional terms of the transaction, which is subject to customary closing conditions, were not disclosed.


About Ness Digital Engineering
Ness is a full lifecycle digital engineering firm offering digital advisory through scaled engineering services. Combining our core competence in engineering with the latest in digital strategy and technology, we seamlessly manage Digital Transformation journeys from strategy through execution to help businesses thrive in the digital economy. As your tech partner, we help engineer your company’s future with cloud and data. For more information, visit ness.com.

About KKR
KKR is a leading global investment firm that offers alternative asset management as well as capital markets and insurance solutions. KKR aims to generate attractive investment returns by following a patient and disciplined investment approach, employing world-class people, and supporting growth in its portfolio companies and communities. KKR sponsors investment funds that invest in private equity, credit and real assets and has strategic partners that manage hedge funds. KKR’s insurance subsidiaries offer retirement, life, and reinsurance products under the management of Global Atlantic Financial Group. References to KKR’s investments may include the activities of its sponsored funds and insurance subsidiaries. For additional information about KKR & Co. Inc. (NYSE: KKR), please visit KKR’s website at www.kkr.com and on Twitter @KKR_Co.

About TRG
Founded in 2002, The Rohatyn Group is an asset management firm focused on emerging markets and real assets, headquartered in New York, with a global presence in 16 cities across the US, Latin America, Europe, the Middle East, India and Southeast Asia. For more information, please visit www.rohatyngroup.com.

Media Contacts

For KKR:
KKR Asia Pacific
Wei Jun Ong
+65 6922 5813
[email protected]
For Ness:
Vivek Kangath
+91 9742565583
[email protected]
For TRG:
Julia-Ambra Verlaine
+1 212 984 3539
[email protected]

KKR Americas
Julia Kosygina and Miles Radcliffe-Trenner
+1 212 750 8300
[email protected]

AdFactors (for KKR India)
George Smith Alexander
+91 98213 56867
[email protected]

Josef Švenda obchodním ředitelem Ness Czech pro finanční sektor

Praha, 26. října 2022: Josef Švenda, zkušený odborník na oblast podnikových aplikací, se stal obchodním ředitelem pro finanční sektor ve společnosti Ness Czech, která patří mezi přední české systémové integrátory a dodavatele ICT řešení.

Josef Švenda přichází do Ness Czech se zkušenostmi, které nasbíral během své bohaté profesní kariéry. Nejvíce času strávil ve vedoucích pozicích ve společnostech Autodesk a Oracle. V Autodesku byl zodpovědný mimo jiné za obchodní aktivity v regionech jihovýchodní a východní Evropy. V Oraclu zastával postupně pozice ředitele české pobočky Oracle, regionálního ředitele pro partnerský prodej a šéfa pražské centrály Oracle Digital. Jeho dalšími působišti byly i společnosti Operátor ICT, CompuGroup Medical či SAP. Věnoval se i vlastním aktivitám, například spoluzaložil bio-data startup Aiomica.

„Chci se zaměřit na nové příležitosti, které finančnímu sektoru přináší digitalizace a změny pracovních postupů. Pro finanční instituce zde leží značný potenciál ve využití podnikových aplikací k optimalizaci svých procesů a zlepšení finančních ukazatelů,“ říká Josef Švenda, obchodní ředitel pro finanční sektor v Ness Czech.

Ve volném čase se Josef Švenda věnuje rodině, čte a pokud má volnou chvilku pro sebe, programuje v pythonu a zdokonaluje se v AI/ML. V minulosti byl také držitelem pilotní licence. V poslední době se účastní projektu Numerai, který pomocí data science předpovídá vývoj na akciových trzích.

O společnostech Ness Czech a Ness Digital Engineering

Ness Czech, přední český systémový integrátor a součást mezinárodní skupiny Ness Digital Engineering, patří mezi největší poskytovatele IT služeb v České republice. Od roku 1993 se profiluje jako průkopník v zavádění nových technologií a softwarových produktů. Mezi nejvýznamnější zákazníky patří například O2 Czech Republic, Komerční Banka a ČÚZK. Ness Digital Engineering je globální poskytovatel komplexních řešení a služeb v oblasti informačních technologií.

OTT in Hospitality: The Future of Streaming Distribution and Consumption for Hotels and their Guests

OTT in Hospitality - Ness

The past few years have been challenging to those in the hospitality industry as the COVID-19 pandemic stalled travel and ongoing inflation inhibits vacations. However, a recent CBRE Hotel Research report shows a strong recovery for the hospitality industry throughout 2022 and beyond, meaning it is critical for hotels and resorts to do all they can to provide excellent guest services and make customers feel right at home.

This means, to a large extent, being able to bring home entertainment on the go, allowing guests to enjoy their favorite content from the convenience of their hotel rooms, whether it comes from a traditional network or is available only through an over-the-top (OTT) service. OTT services offer video content streamed directly from the Internet and bypassing traditional multichannel video program distributors (MVPDs). In recent years, it has become the predominant way for consumers to engage with content, with platforms like Netflix and Disney+ boasting incredible subscriber growth at a time where the traditional video package at home seems to be falling out of fashion.

Hoteliers are scrambling to integrate OTT content into their entertainment services. Here are some ways that hospitality providers can innovate in this space:

App Enabled In-Room Entertainment

Incorporating OTT services into the in-room entertainment systems will benefit hospitality organizations that aim to provide guests with access to their preferred platforms during their stay. This requires an evolution in their hospitality platforms to enable delivery of streaming services. Some hotels have implemented hybrid solutions, with systems that combine traditional television services delivered via existing coaxial cables, and OTT apps delivered either via Wifi or ethernet using a set top box in every room.

Alternatively, some hotels are choosing Internet-only deployments using Smart TVs (TVs that connect to the Internet via ethernet or Wifi) and either forgo the traditional TV package or offer it via an app.

In some cases, hotels offer guests a simpler option to stream content using their own devices: casting. This is allowing guests to pair their own devices with either the TV directly or a connected streaming device so that they can use their smartphone or tablet to access the apps and the TV to watch the content from the comfort of their rooms. This helps hospitality service providers hyper-personalize experiences to guests, but also requires investment in technology and equipment to enable device pairing and casting content from third-party apps.

Novel ways of transforming the in-room experience

These connected platforms also offer hoteliers the opportunity to transform the guestroom experience through content discovery and personalization. Hotels can offer entertainment with preinstalled OTT apps, making guests feel more at home by allowing them to use their own subscription to view their preferred OTT service, while also providing their own content, including concierge information and amenity details, unifying and streamlining the entertainment experience.

Furthermore, Smart TVs and streaming devices are revolutionizing the capabilities of guestroom management. Fully integrated and tailored hospitality management solutions are now offering guest control over room amenities like lights, air conditioning and thermostats directly from their TV. With the increased presence of voice-powered virtual assistants, investment in connected experiences can set hospitality providers up for future success as the industry progresses to voice-directed, hands-free control and entertainment.

Simplifying the User Experience

One of the obstacles to a simplified guest entertainment experience is having to log in to each of the OTT services from their hotel room. TV apps still require keying in a password with a remote control or some kind of two-factor authentication using a mobile device, which can be discouraging for some guests. Additionally, some guests may be concerned about entering their credentials into what is seen as a public device for fear of having their information stolen; however, most hotels clear user credentials upon check-out, mitigating any risks.

An area of consideration would be leveraging loyalty programs to connect to a guest’s OTT services. Hotel chains could work with major platforms, creating a linkage between their members and their favorite OTT services and reducing friction when attempting to watch content through their in-room entertainment system.

This new layer of customer data could be further leveraged by hotels in creating a hyper-personalized content experience in future visits. Their in-room entertainment system not only could automatically log in users, but also recommend favorite shows, next episodes, sporting events, and elevate the user experience to a whole new level.

Negotiating meaningful partnerships

OTT streaming offers many benefits to new-age consumers within the hospitality industry, but more importantly, it provides limitless integration opportunities for hotels once they commit to investing in the infrastructure. No forward-thinking organization should, however, undertake a digital transformation of this nature without a proper technology partner. Whether it be a complete OTT overhaul for global hotel chains or customized welcome screens and interactive program guides, experienced digital engineering companies can offer counsel and expertise to advise on which level of investment is best for a growing business.

About Hospitality Technology is the only media and predictive intelligence resource exclusively dedicated to helping both hotel and restaurant operators better employ technology to improve the performance of their businesses. Since 1997, technology service providers have leveraged HT to connect with hotels and restaurants in meaningful ways to build stronger and more productive business relationships. The HT audience includes key corporate and franchise IT stakeholders across technology, digital, finance, marketing, operations, and senior executives. For more information, visit: https://hospitalitytech.com/

RFPB Template Guide

The free version of APIX.XL™ includes a Microsoft Excel template demonstrating the rich user experiences enabled by API-Excel integration.

The RFPB Template file is an Excel application that reconciles a client’s position data against data from a prime broker and displays any breaks as well as data availability. The RFPB Template sources data from an API that is included with APIX.XL™.

The breaks reported in the template roll up to the Entity level and can be drilled down to the Account, Position, and Security level. The template also displays any margin calls and call requirements. In addition, it reconciles current-day and prior-day data from the broker, displays a summary of differences in margins and market values, and lists the top-10 margin differences.

The following guide provides an overview of the RFPB Template.

Getting Started

When the RFPB Template is first opened, the user may be prompted to enable editing.
Picture 1
The template itself will be empty. To call data, click the Refresh button located in the upper right hand of the dashboard.
Image 18


Explanation of Breaks

Break Report: Out of 141 total positions, there are 7 position breaks across 6 accounts and 4 entities. There is a total of 59 accounts and 7 entities.

Data Availability: Out of 141 total positions, data for 5 positions is missing from the broker data set and 136 positions are available. The 5 missing data items are across 5 accounts and 4 entities.

The Entities Tab

Click on the ENTITIES tile on the dashboard to populate the dashboard with Entity-level data.
Image 19

The Entities tab displays a data summary rolled up to the Entity level. The column to the right of Credit Cash is red for Entities with underlying breaks, and the number in this column indicates the number of accounts within the Entity that have breaks.

Image 20

Clicking on an Entity will open up the Accounts tab in the workbook and allow the user to view Accounts under the entity.

Image 21

Clicking on any summary tile on the right-hand side of the dashboard (Breaks, Data Issues, Margin Calls) will filter the data to display only items related to the tile. For example, if the Breaks tile is clicked, the data table will only display the entities that have breaks.

Image 22

Filters can be cleared and predefined filters can be applied by making a selection from the Filters dropdown on the left-hand side of the dashboard. Similarly, various predefined sorting can be applied by making a selection from the Sort by dropdown on the left-hand side of the dashboard.

Image 23

The Accounts Tab

The Accounts tab lists all accounts for the selected Entity. Accounts with underlying breaks are highlighted in red. Clicking on an Account allows the user to view underlying Positions.

image 24

The Positions Tab

The Positions tab lists all securities for the selected Account. Securities with underlying breaks are highlighted in red. Clicking on a Security ID allows the user to view details for the security in the Position Drilldown tab.

image 25

The Position Drilldown Tab

The Position Drilldown tab lists values for client and broker files for the selected security. Fields values that do not match are highlighted in red.

image 26

Managing Multiple Versions of an API

Multiple versions of an API can be loaded into APIX.Hub™. This makes it simple to switch between different environments. The following steps allow the user to upload a new version of an API:

  1. Launch Manage API window by clicking the Manage APIs button on the APIX.XL ribbon.Manage API
  2. Delete the API for which a new version is to be loaded by clicking the DELETE button. Note: This will only delete the API definitions locally; it will not delete it from the hub.Delete API
  3. Load the new version of the API using one of the methods outlined in Loading an API Locally, making sure that EXCEL CATEGORY is different from what is already in the hub. To ensure the APIs have been loaded, launch the Manage APIs window by clicking the Manage APIs button.Local API
  4. Publish the API to the hub, ensuring that the NAMESPACE and SHORTNAME values match with the existing version in the hub and that VERSION is different. Note: Version can be alphanumeric, and it is advisable to use a value (For example, MyAPI_Dev, MyAPI_Prod). If OFFICIAL is checked, the newly uploaded API version will be the official version.
  5. To verify that multiple versions of the API have been loaded, launch the Manage API Auth window by clicking on the Manage API Auth button on the APIX.XL ribbon.Manage API
  6. Click the API VERSION drop-down to view available versions.API Version

Publishing an API to APIX.Hub™

APIs can be published when APIX.XL™ is connected with APIX.Hub™. The following steps allow the user to publish locally loaded APIs to APIX.Hub™:

  1. On the APIX.XL ribbon, click the Manage APIs button.Manage API
  2. The window that displays will list all the APIs that are locally loaded as well as those that are in APIX.Hub™.
  3. Identify the local API that is to be published and click the PUBLISH TO HUB button.Publish Hub
  4. In the window that appears, enter the NAMESPACE, SHORTNAME, and VERSION for your API. Then select APIX.Hub™ in the HUB drop-down. Then click the PUBLISH button. Note: If publishing a new version of an existing API, ensure that NAMESPACE and SHORTNAME match the existing API.Publish
  5. The message below indicates that the API was successfully published to APIX.Hub™.Success
  6. To verify success, open the Manage API window (See Step 1).
  7. The TYPE for the API should say Hub.API Type

Configuring API Authentication

The authentication method for an API is set using the Manage API Auth form. The following steps allow the user to configure authentication settings for APIs as well as to copy settings from one API to another:

  1. On the APIX.XL ribbon, click the Manage API Auth button to open the Manage API Auth form.Manage API
  2. APIX™ currently supports the following authentication types: SSL Certificate, JWT OAuth, OAuth, Token, NTLM, and Basic Authentication.Auth Types

The authentication types currently supported by APIX™ are detailed below:

SSL Certificate
JWT OAuth
OAuth
Token
NTLM
Basic Authentication

SSL Certificate

  1. Select SSL_Certificate as the AUTH TYPE and click the EDIT button.SSL
  2. Once the Certificates form opens, choose between User storage or Local machine storage. The selection will display all available certificates for the chosen location.SSL Storage
  3. Select the correct certificate and click the SAVE button.
  4. The user will be returned to the Manage API Auth form. There, CURRENT SETTINGS will display the details of the selected authentication type. Review and click the OK button.Manage

JWT OAuth

  1. Select JWT_OAuth as the AUTH TYPE and click the EDIT button. JWT Edit
  2. In the JWT OAUTH form, enter the CLIENT ID, browse and select the PRIVATE KEY and PUBLIC CERTIFICATE files, and choose the ENVIRONMENT.JWT Environment
  3. Click the SAVE button.
  4. The user will be returned to the Manage API Auth form. CURRENT SETTINGS will display the details of the selected authentication type. Review and click the OK button.JWT Manage

OAuth

  1. Select OAuth as the AUTH TYPE and click the EDIT button.OAuth edit
  2. In the OAUTH form, enter URL, CLIENT ID, CLIENT SECRET, and SCOPE (if applicable).OAuth Scope
  3. Click the SAVE button.
  4. The user will be returned to the Manage API Auth form. CURRENT SETTINGS will display the details of the selected authentication type. Review and click the OK button.OAuth Manage

Token

  1. Select Token as the AUTH TYPE and click the EDIT button.Token Edit
  2. In the Token form, select TYPE and enter TOKEN NAME and TOKEN VALUE.Token Type
  3. Click the SAVE button.
  4. The user will be returned to the Manage API Auth form and CURRENT SETTINGS will display the details of the selected authentication type. Review and click the OK button.Token Manage

NTLM

  1. Select NTLM as the AUTH TYPE and click the OK button. NTLM Edit

Basic Authentication

  1. Select Basic as the AUTH TYPE and click the EDIT button.Basic edit
  2. In the Basic form, enter USER ID and PASSWORD.Basic form
  3. Click the SAVE button.
  4. The user will be returned to the Manage API Auth form and CURRENT SETTINGS will display the details of the selected authentication type. Review and click the OK button.Basic manage

Copying Authentication Settings

  1. Launch the Manage API Auth form by clicking the Manage API Auth button on the APIX.XL ribbon.
  2. Identify the API Auth settings that are to be copied and click the COPY button.Settings Edit
  3. On the Copy form, select the APIs to which the settings should be applied and click the COPY button.Settings
  4. Click the OK button on the confirmation window.
  5. The user will be returned to the Manage API Auth form and CURRENT SETTINGS for the selected APIs will display the details of the copied authentication type. Review and click the OK button.Settings manage

Loading an API Locally

The following steps allow the user to load an API locally.

  1. On the APIX.XL ribbon, click the Load API button.loading locally
  2. API definitions can be loaded from a URL, by uploading a Swagger file, or by entering the Swagger definition as text.API definations
  3. To load from a URL, select the URL tab and enter the URL for the API definition in the text box.Upload URL
  4. To load from a file, select the FILE tab and then click the BROWSE button to select the file that contains the API definition.Upload file
  5. To load from text, select the TEXT tab and enter the API definition as JSON into the text box.Upload text
  6. Once the appropriate selection is made, click the REVIEW button.
  7. The screen that appears will list all available endpoints in the form of Excel function names and will allow various values to be edited before creating the functions. Enter desired category name in the XL CATEGORY field.Category name
  8. To add a prefix to function names, enter the desired prefix in the FN Prefix field and click the UPDATE button. The function names will update. This step is optional.FN Prefix
  9. Function names can be edited as needed. To exclude a function from being created, un-check the INCLUDE IN EXCEL checkbox next to it.
  10. Once edits have been made, click the ADD FUNCTIONS TO EXCEL button to create the functions.Add Function
  11. The following message will indicate that the functions were created successfully.Success
  12. To verify that the functions were created, select an empty cell and click the fx symbol next to the formula bar.
  13. Once the Insert Function window appears, click the category drop-down and look for the category entered in Step 8. Selecting a category will display all the functions included in the category.Picture 1

Utility Functions

Overview

APIX.XL™ includes a number of utility functions. The following steps allow the user to access and view these functions.

To view the list of APIX™ utility functions, do the following:

  1. Launch the Insert Function window by clicking the fx symbol next to the formula bar.functions
  2. Select the A_utilities category from the category drop-down.Utilities

The utility functions included with APIX™ are detailed below:

a_util_create_array
a_util_create_dictionary
a_util_create_file
a_util_create_table
a_util_expand
a_util_flatten
a_util_path
a_util_read_file
a_util_render_array
a_util_render_dictionary
a_util_render_table
a_util_render_table_hierarchical
a_util_to_csv
a_util_update_json

a_util_create_array

This function generates and returns a textual representation for a range of Nx1 or 1xN selected cells. The result is displayed in the cell where the function is defined. This function may be used inside another function. Data types in the selected cell are converted to textual representation according to the rules.

Parameter List:

Rng (required)
Input range from Excel.

OutputType (optional)
Format of output string (JSON). Default is JSON.

Parameter
Parameter

a_util_create_dictionary

This function generates and returns a textual representation for a range of Nx2 or 2xN selected cells. The result is displayed in the cell where the function is defined. This function may be used inside another function.

Parameter List:

Rng (required)
Input range from Excel.

OutputType (optional)
Format of output string (JSON). Default is JSON.

Parameter 5
Parameter 6

a_util_create_file

This function creates a file to the file system based on the range selected. This function can write the contents of a single cell or a range of cells. When writing a range of cells, the data can be written out as JSON or CSV.

Parameter List:

Rng (required)
Input range from Excel.

FolderPath (required)
Folder in which to write the file.

FileName (optional)
Name of the file. If FileName is blank, the full path of the file should be provided in the folder_path parameter.

FileType (optional)
Output format of file (JSON, CSV). Default is JSON.

Parameter 7
Parameter 8

a_util_create_table

This function generates and returns a textual representation for a range of NxM selected cells. The result is displayed in the cell where the function is defined. This function may be used inside another function.

Parameter List:

Rng (required)
Input range from Excel.

HeaderOrientation (optional)
Row or column. The default is a row.

TableType (optional)
Record or column. Default is record.

OutputType (optional)
Format of string (JSON). Default is JSON.

Parameter 7
Parameter 8

a_util_expand

This function is useful to visualize the structure of the supplied data. It renders the data into a cell range starting directly below the cell where this function is defined, with every piece of data in the input rendered in one cell each, positioned within the cell range according to its logical position within the data structure.

Parameter List:

Json (required)
Input JSON string.

JsonPath (optional)
Path to drill down to a node. Default is root.

Parameter 11
Parameter 12

a_util_flatten

This function is useful for learning the JsonPath expression associated with each piece of data of the supplied structure. It renders the supplied structured data into an Nx2 cell range, starting directly below the cell where this function is defined. Every piece of data in the data structure is rendered in one cell each in the second column. For each one, the JsonPath expression corresponding to that piece of data is placed in the corresponding cell of the first column.

Parameter List:

Json (required)
Input JSON string.

JsonPath (optional)
Path to drill down to a node. Default is root.

Parameter 13
Parameter 14

a_util_path

This function applies a JsonPath expression to a JSON structure, returning the result in the same cell. Data types in the textual representation are rendered appropriately according to the rules.

Parameter List:

Json (required)
Input JSON string.

JsonPath (optional)
Path to drill down to a node. Default is root.

Parameter 15
Parameter 16

a_util_read_file

This function reads data from a file in the file system and returns the value to the cell where the function is defined.

Parameter List:

Path (required)
Path to read file from.

JsonPath (optional)
Path to drill down to a node. Default is root.

InputType (optional)
Format of input string (JSON). Default is JSON.

MinifyFile (optional)
Should be used to remove new lines. Default is true.

Parameter 17
Parameter 18

a_util_render_array

This function renders the supplied textual representation of an array or list into a cell range starting directly below the cell where this function is defined, with each element of the array or list rendered in one cell each. By default, the elements are rendered in a Nx1 range (i.e., vertically) but the Orientation parameter can be used to change that to a 1xN range (i.e., horizontally).

Parameter List:

Json (required)
Input JSON string

JsonPath (optional)
Path to drill down to a node. Default is root.

Orientation (optional)
Column or row. Default is column.

InputType (optional)
Format of input string (JSON). Default is JSON.

ReturnArray (optional)
Returns an Excel function array instead of rendering the range below the cell.

Parameter 19
Parameter 20

a_util_render_dictionary

This function renders the supplied textual representation of an array or list intThis function renders the supplied textual representation of a dictionary into a cell range starting directly below the cell where this function is defined. The keys and the corresponding values are rendered vertically in one cell each, with the keys in the first column and the values in the second column. The Orientation parameter can be used to cause the keys and values to be rendered in rows instead.

Parameter List:

Json (required)
Input JSON string

JsonPath (optional)
Path to drill down to a node. Default is root.

Orientation (optional)
Column or row. Default is column.

InputType (optional)
Format of input string (JSON). Default is JSON.

ReturnArray (optional)
Returns an Excel function array instead of rendering the range below the cell.

Parameter 21
Parameter 22

a_util_render_table

This function renders the supplied textual representation of a table into a cell range starting directly below the cell where this function is defined. The headers are rendered in the first row, each in one cell, and the rest of the data is rendered in the subsequent rows. The HeaderOrientation parameter can be used to cause the headers and values to be rendered in column instead. It is also possible to change the order in which the headers are rendered and verify there are no missing values for those headers with the Columns parameter.

Parameter List:

Json (required)
Input JSON string

JsonPath (optional)
Path to drill down to a node. Default is root.

Columns (optional)
Determines order of columns and checks for presence.

HeaderOrientation (optional)
Row or column. Default is row.

InputType(optional)
Format of input string (JSON). Default is JSON.

Index (optional)
Index column is displayed only once for all groups. Used in conjunction with GroupBy parameter.

GroupBy (optional)
Group by column is displayed as extra header row. Used in conjunction with Index parameter.

ReturnArray (optional)
Returns an excel function array instead of rendering the range below the cell.

JsonPathForValue (optional)
Use this JsonPath in case value is a json object.

ColumnDelimiter (optional)
Use this when cell values are delimited (e.g., pipe, comma).

ColumnJsonPathOrDelimited (optional)
JSON to extract columns from input JSON or delimited string.

Flatten (optional)
Flag to determine if the parsed JSON should be flattened out for child objects.

AdditionalColumns (optional)
Comma separated list of JsonPaths to pick additional columns from JSON blob.

UniqueKey (optional)
Key in the input JSON to show only unique records in the table.

IgnoreBlanks (optional)
Flag to control whether to ignore blank rows in the return dataset.

RenderAtNamedRange (optional)
Name of a range to render the return dataset.

Parameter 23
Parameter 24

a_util_render_table_hierarchical

This function renders the supplied textual representation of a table into a cell range starting directly below the cell where this function is defined. Each field name is rendered as a header and the corresponding value of the field is rendered as the field value represented as text. The field value can be an object, an array, or text.

Parameter List:

Json (required)
Input JSON string

JsonPath (optional)
Path to drill down to a node. Default is root.

Columns (optional)
Provide mapping for columns in order to display custom column headers in rendered data.

ParentKey
JSON path for the starting point to recursively go through the hierarchical data.

JsonPathForValue
Path to drill down in case a value is also a JSON object.

Parameter 25
Parameter 26

a_util_to_csv

This function allows the conversion of an Excel range into comma separated string. This can then be reused within the sheet or exported into a file.

Parameter List:

Rng (required)
Input range from Excel.

Parameter 27
Parameter 28

a_util_update_json

This utility function allows updating a JSON from an Excel range. This can be used in conjunction with the flatten function. Once the flatten function renders a range in Excel, the user can update the value in Excel and generate the updated JSON in Excel. The updated JSON can be sent back to server or reused in Excel.

Parameter List:

Json (required)
Input JSON string.

Parameter 29
Parameter 30

test