Advanced Search
Search Results
140 total results found
Release Notes
Release Notes: (June, 2023) Enhancement: Option to set a title and subtitle in Bizdata Frame, providing better context and clarity for the displayed data. Enhancement in the Worksheet Widget by addition of a user-friendly sorting UI and functionality, ena...
Generate a OAuth 1.0 Signature or Store a Code Response in a User Defined Variable
When we want to run a python script and the response will come from the same script and has no relation with the data which is flowing in this case we will use a variable Responsedata as an empty array [], before the start of script and will append the respons...
Connecting Data Sources
Connecting Salesforce as a Source : Step 1 : Choose the Source Type as 'API'. Step 2 : Enter 'Salesforce' in the product search field and select 'Salesforce' from the dropdown options. Step 3 : According to the requirements, pick the Salesforce busine...
Form a JSON Object from array of array
Input Data with Singleline Array { "bizdata_dataset": { "values": [["Order ID", "Country", "City", "Customer Type", "Item Category", "Item", ...
Data Target - Database SQL Examples
SQL Actions is Insert This will go inside the SQL Statment of Database Target """Insert into table_name (column1,column2,column3,column4) values (?,?,?,?)""","column1","column2","column3","column4" SQL Actions is Update This will go inside the SQL St...
Environment Settings
In eZintegrations, environment settings are used to store and manage dynamic values that can be reused across multiple requests and collections. These settings are helpful for streamlining your API testing and ensuring consistency in your requests. Environment...
Data Orchestration
Database Description : The Database operation allows users to perform essential SQL actions such as Insert, Update, Delete, or execute PLSQL procedures. This functionality empowers users to seamlessly interact with the database, enabling efficient data mani...
URL Parsing
Below is the example where in the current context, we are receiving a Url in the 'name' key with a value like '{{base_url}}abc/xyz/pqr,' but we need the Url to be in the format '{{base_url}}abc%xyz%pqr.' To achieve this, we will utilize the following Python co...
Form a JSON Object based on the key and values available in JSON Dataset
Below is the example to form a JSON Object based on the key and values available in the JSON dataset Input Data with singleline json { "id":123, "name":"sample", "lastname":"dataset", "attributes":[ { ...
Convert Empty String in a JSON to a "null" value
Below is the example as how user can convert a empty string to a "null" value in a JSON dataset. Just use the PyCode editor in the Python Code Operations with the below example code. This will change the entire records of JSON from empty string to "null" Res...
Connecting MS-SQL or Oracle Database to Salesforce Using Bizdata Universal API
User Guide: Configuring Source as MS-SQL Database or Oracle Database using Bizdata Universal API and Target as Salesforce This user guide provides step-by-step instructions on how to configure the source in Bizdata Universal API for connecting to either an...
REST API Target
When working with OAuth 2.0 and sending data in URL-encoded format, you can provide values in the 'refresh token endpoint body' field in the following format : Refresh Token Endpoint Body : { "grant_type":"password", "client_id":"XXXXXXXXXXXX...
Authorization
eZintegrations platform supports all sort of Authorization for any standard APIs like REST API, SOAP API, gRPC or GraphQL. The major Authorizations are :- API Key Basic Authentication OAuth1.0 OAuth2.0 AWS Signature NTLM Authentication Custom Algorit...
Bizdata Universal API for Database
Bizdata Universal API- Databases Bizdata Universal APIs are a comprehensive collection of flexible and adaptable application programming interfaces (APIs) designed to facilitate efficient connectivity and seamless access to a wide range of databases. These ...
Data Source - Bizdata Data Lake
Bizdata Data Lake is a search engine based NO-SQL database owned by Bizdata. Users can ingest petabyte, zettabyte, yottabyte of records both structured and unstructured for Analytics, Storage, Machine Learning and deep learning. Bizdata Data Lake Source is a...
Rename JSON Key based on other key's value
In the below python code examples user can dynamically change JSON key based on other key's value Input Data with multiline json { "attributeid": 212077, "attributename": "SKU", "attributevalue": "999898", ...
Filter
Filter section is available under 'Widget Parameter' Here is a guide to use Filters: 1. A dataset has column name Regions and within it values are East, West, North and South. Result for only West is requiredFilter to be used: Regions: "West"i.e. column: ...
SFTP API
Introducing Secure File Transfer Protocol (SFTP) APIs With our state-of-the-art SFTP APIs, connecting to any server and effortlessly managing your files has never been more straightforward! Unmatched Security: Rest easy, knowing your data is in safe hands. O...
Connecting My-SQL to Salesforce Using Bizdata Universal API
User Guide: Configuring Source as My-SQL Database using Bizdata Universal API and Target as Salesforce 1: Login to eZintegrations: enter username and password 2: create IB(Integration Bridge): To create Integration Bridge click on eZintegrations tab a...
Connecting Data Targets
Connecting Oracle Netsuite as a Target : Step 1 : Choose the Target Type as 'API'. Step 2 : Enter 'Oracle NetSuite' in the target name field and select 'Oracle NetSuite' from the dropdown options. Step 3 : According to the requirements, pick the Oracle Ne...