BlogBlogtypeA post on somebody's own site or a community platform. Nobody edits it after publication, so it dates from the day it was written.See every one →SAP Community

Upload data from excel in CAP (Node.js)

Mass upload from a spreadsheet, both halves shown: an entity marked @cds.persistence.skip to receive the file, an INSERT built from the parsed rows, and a list report extended with the upload button that starts it.

Where it sits

Explains
Database connectorsCAPDatabase connectorscapabilityConnecting an application’s data model and queries to a database, including the differences in supported queries, types and schema management between database implementations. Changing an existing schema belongs to [schema evolution](capability:schema-evolution).Fiori annotationsCAPFiori annotationscapabilityDescribing a service so a Fiori client can render it without hand-written UI code — titles, value helps, hierarchies and visibility expressed as model annotations rather than screen logic.
Since then
Database connectors has changed twice since this was published, most recently in @sap/cds 10.1.0, 2026-09-07
Source
reachable

Who is behind it

KM11author

Before you read it

read from the page
ApplicabilityCore changedDatabase connectors has changed twice since this was published, most recently in @sap/cds 10.1.0, 2026-09-07.

This is a derived prompt to re-check the work, not a claim that the work is wrong. Exact stale statements are recorded separately after editorial review.

Properties

About this work

declared and crawled
Published
declared
Published on
declared
Views
crawled
22,155

What was found on the page

derived
Prose
derived
200 words
Code blocks
derived
2
Repository links
derived
1

For database-connectors

on the edge
Applies in
authored
cap

For fiori-annotations

on the edge
Applies in
authored
cap

More on this95

Group by95 of 95 pieces
Piece, what it offersStill applies
Also explainingDatabase connectors95
CAP Foundry: Engineering SAP CAP Applications from Business Intent with Guardrailed AI
SAP Community, Shahid
nothing recorded
Connect SAP CAP (Node.js) to On-Premise/Private PostgreSQL using SAP Cloud Connector
SAP Community, KalaikovanThe reasoningA recipe
Core changed
Reading Between the Lines: Under-Documented Fiori Elements Capabilities in SAPUI5 1.149
SAP Community, Sören Leibach
nothing recorded
Dynamic Criticality in SAP CAP Using Fiori Elements and Node.js
SAP Community, Pranesh_SDThe reasoningA recipe
nothing recorded
Deep Insert in SAP CAPM Using Composition and Fiori Elements
SAP Community, Talari Hari KumarThe reasoningA recipeRunnable code
nothing recorded
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-4]
SAP Community, sanjucsThe reasoningA recipe
Core changed
From SEGW and Legacy UI5 to RAP with ARC-1
blog.zeis.de — Marian Zeis, Marian Zeis, part 7 of 10Runnable codeThe reasoning
New majors
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-3]
SAP Community, sanjucsThe reasoning
nothing recorded
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-2]
SAP Community, sanjucsThe reasoningRunnable code
nothing recorded
Fullstack CAP Application with HANA Cloud (Decoupled Architecture) [Part-1]
SAP Community, sanjucsThe reasoningA recipeRunnable code
Core changed
Build BTP CAP App with Fiori Integration – Part 2: Implementing End to End App
SAP Community, SuryaRamesh, part 2 of 2The reasoning
nothing recorded
Building a CAP App with Fiori Integration – Part 1: Environment & HANA Cloud Setup
SAP Community, SuryaRamesh, part 1 of 2The reasoning
nothing recorded
SAP CAP on HANA XSA: Scaling Industrial Data Applications Beyond the Cloud
SAP Community, rgadirovThe reasoningRunnable code
Core changed
Part 2: Creating and Deploying a CAP Application with PostgreSQL, Hyperscaler Option
SAP Community, yashbhosle789, part 2 of 2The reasoningA recipe
Core changed
Part 1: Creating and Deploying a SAP CAP Application with SAP HANA on SAP BTP (Cloud Foundry)
SAP Community, yashbhosle789, part 1 of 2The reasoningA recipe
Core changed
Building an Enterprise Application Using Fiori Elements and CAP - Part 1
SAP Community, Farooq, part 1 of 3The reasoning
nothing recorded
Building an Enterprise Application Using Fiori Elements and CAP – Part 2
SAP Community, Farooq, part 2 of 3The reasoning
nothing recorded
Building an Enterprise Application Using Fiori Elements and CAP – Part 3
SAP Community, Farooq, part 3 of 3The reasoningRunnable code
Core changed
Create a CAP Application with SAP HANA Cloud from Scratch and Deploy to Cloud Foundry
SAP Community, MaheshSirsat1708The reasoningA recipe
Core changed
CAP JavaでObject Pageの項目の動的な入力制御を実装する
Qiita, Mio Yasutake
nothing recorded
Creating a Hybrid CAP (Node.js) Profile with PostgreSQL on BTP from Business Application Studio
SAP Community, valentincadartThe reasoningRunnable code
Core changed
Tree-Table Support in CAP is Now Generally Available
SAP Community, BirgitSThe reasoning
nothing recorded
Lets Talk to the Database - CAP & SQLite Powered by Google Gemini-2.5-Pro
SAP Community, ShivamShuklaSAPThe reasoning
nothing recorded
SAP CAP With Prostgres Serice in BTP
SAP Community, satya-dev
nothing recorded
Using HANA Cloud’s "VECTOR_EMBEDDING" Function in CAP
SAP Community, Mio YasutakeThe reasoningRunnable code
nothing recorded
Visualizing Your SAP Bill of Materials Using CAP, Fiori elements, and the UI5 Network Graph
SAP Community, Marian ZeisThe reasoningRunnable code
Core changed
SAP CAP Lessons Learned: SQLite is single threaded, HANA is not
SAP Community, LucasMagriniRigo
nothing recorded
SAP CAP Lessons Learned: Run a CAP app using SQLite on SAP BTP - Cloud Foundry
SAP Community, LucasMagriniRigoThe reasoning
nothing recorded
Configure an SAP CAP Application to Connect to an SAP HANA Cloud Database in Another Global Account or Subaccount
SAP Community, JhoelAnthonyRamosRomeroPEThe reasoning
nothing recorded
Use SAP CAP SAPUI5 Smart Filter to Show Value Help that are not Associated Entitites
SAP Community, JhoelAnthonyRamosRomeroPE
nothing recorded
Calling bound / unbound CAP actions from Fiori elements application.
SAP Community, vidhyasagarmuleThe reasoning
nothing recorded
SQLite as database for a multi-target (/productive) CAP Application
SAP Community, Christopher_KetzlerThe reasoningA recipeRunnable code
Core changed
Extend Upload Set with Table to Fiori Elements and utilize Object Store
SAP Community, Kazuhiko TakataThe reasoningRunnable code
Core changed
Using Postgresql Database in Cloud Application Programming model
SAP Community, Arun KrishnamoorthyThe reasoningA recipeRunnable code
Core changed
Sharing SAP HANA Cloud instance to multiple subaccounts and creating HDI containers
SAP Community, Kazuhiko TakataThe reasoningRunnable code
Core changed
2024/01最新版!Productivity Toolsを使ったCAPバックエンド開発②~HANA Cloud編~
SAP Community, takayuki_tanakaA recipe
Core changed
CAP with Fiori Elements: Actions on List Report / Object Page using Annotations - Part1
SAP Community, Ajit_K_Panda, part 1 of 2The reasoningA recipeRunnable code
Core changed
CAP with Fiori Elements: Actions on List Report / Object Page using Annotations – Part2
SAP Community, Ajit_K_Panda, part 2 of 2The reasoningRunnable code
Core changed
CAP with Fiori Elements: Configure Multiple Views on List Report Tables
SAP Community, Ajit_K_PandaThe reasoningRunnable code
Core changed
CAP - Dynamically hide UI facets in Fiori Elements
SAP Community, AjayRathoreA recipe
Core changed
CAP PostgreSql setup local debugging using Docker - Part 2
SAP Community, ramonlee5A recipe
Core changed
CAP with PostgreSQL DB alternate to HANA Cloud DB - Part 1
SAP Community, ramonlee5The reasoning
nothing recorded
Open Sourcing CAP – how to learn more or get involved
SAP Community, Fempel
nothing recorded
Create Fiori List Report with object page using CAPM(node.js) Service
SAP Community, Md_sanaullahThe reasoning
nothing recorded
Developing SAP Fiori Element application by using SAP Cloud Application Programming Model
SAP Community, shobhitThe reasoningA recipeRunnable code
Core changed
SAP CAP (Java) with Amazon Aurora PostgreSQL
SAP Community, shanthakumar_krishnaswamyThe reasoningA recipeRunnable code
Core changed
SAP CAP (Java) with Azure Cosmos DB for PostgreSQL
SAP Community, shanthakumar_krishnaswamyThe reasoningA recipeRunnable code
Core changed
Run and Deploy SAP CAP (Java) with PostgreSQL using Official Database Adapter @cap-js/postgres
SAP Community, shanthakumar_krishnaswamyThe reasoningA recipeRunnable code
Version drift
Lets Deep dive into CAPM and HANA Cloud --> HANACap
SAP Community, shivamshukla12The reasoningRunnable code
Core changed
Run and Deploy SAP CAP (Node.js or Java) with PostgreSQL on SAP BTP Cloud Foundry
SAP Community, TiaXuThe reasoningA recipeRunnable code
Core changed
Building an Analytical List Page with CAP OData V4
SAP Community, Mio YasutakeThe reasoningA recipeRunnable code
Gone quiet
Run and Deploy SAP CAP (Java) with PostgreSQL on SAP BTP Cloud Foundry
SAP Community, shanthakumar_krishnaswamyThe reasoningRunnable code
1 stale part
Fiori Elements Analytical Table with CAP: Does it work with V2 and V4?
SAP Community, Mio YasutakeThe reasoningRunnable code
Core changed
CAP with Fiori Elements: Side Effects, Custom Actions, Dynamic Expressions
SAP Community, Ajit_K_PandaThe reasoningRunnable code
Core changed
SFSFとHANA Cloudを使用するCAPのアプリケーション開発
SAP Community, rasaiA recipeRunnable code
Core changed
How to create an API to run a HANA Cloud Stored Procedure in Cloud Foundry
SAP Community, gonzalo_hernan_sendraThe reasoningRunnable code
Core changed
Distributed Resiliency of SAP CAP applications using SAP HANA Cloud (Multi-Zone Replication)
SAP Community, shanthakumar_krishnaswamyThe reasoning
nothing recorded
Useful CAP CDS and Fiori Commands to Accelerate Development and Deployment
SAP Community, TiaXu
nothing recorded
Testing your CAP HANA Artifacts with jest – including multitenancy, hdbprocedure and hdbview
SAP Community, TristanThe reasoningA recipeRunnable code
Core changed
How I migrated my on-prem xsa cds3+hana solution to cds6+sqlite
SAP Community, alex_myakinkiiThe reasoningRunnable code
Core changed
Display of hierarchical data in SAP Fiori elements using SAP Cloud Application Programming Model
SAP Community, OliverKlemenzThe reasoningRunnable code
1 stale part
Case-insensitive filters in Fiori Elements (List report + CAP)
SAP Community, Kishannaicker
nothing recorded
Extend SAP SuccessFactors on SAP BTP with CAP - Develop the SAP Fiori Elements Application
SAP Community, ale_biagiThe reasoning
nothing recorded
Extend SAP SuccessFactors on SAP BTP with CAP - Deploy to SAP HANA Cloud
SAP Community, ale_biagiThe reasoning
nothing recorded
Build and deploy a CAP Project Node.js API with a SAP Fiori Elements UI and a managed approuter configuration
SAP Community, jlongThe reasoningA recipeRunnable code
Core changed
The SAP Fiori elements feature showcase with CAP CDS annotations
SAP Community, stefaniehagerThe reasoning
nothing recorded
Tips and Tricks for Working with Annotations in CAP Projects using Language Server Protocol (LSP) capabilities
SAP Community, maryana_nabokaThe reasoning
nothing recorded
Build SAP Overview Page using SAP HANA Cloud & SAP CAP service annotations in Visual Studio Code
SAP Community, Sai_Nithesh_GThe reasoningA recipeRunnable code
Core changed
Create a Business Service using CDS, Node.js, SQLite and a OData service
SAP Community, raybantonThe reasoningA recipeRunnable code
Core changed
Deploying CAP services with the in-memory SQLite database
SAP Community, liam_mischewskiThe reasoning
nothing recorded
SAP CAP Remote Services & SAP Fiori Elements
SAP Community, Former MemberThe reasoningA recipeRunnable code
Core changed
From R/3 ABAP to CAP/Fiori Elements on SAP BTP- Deployment
SAP Community, former_member231477Runnable code
Core changed
cds deploy to sqlite in-memory database
SAP Community, AndrewBarnard
nothing recorded
From R/3 ABAP to CAP/Fiori Elements on SAP Cloud
SAP Community, former_member231477The reasoningRunnable code
Core changed
Simple steps to deploy your CAP project to HANA cloud
SAP Community, OmPrakashJhaThe reasoning
nothing recorded
SAP BTP Showcase - Use SAP Cloud Application Programming to do Native Development on HANA Cloud
SAP Community, former_member271284The reasoningA recipeRunnable code
Core changed
SAP BTP Showcase – SAP Continuous Integration and Delivery (SAP CI&D) for SAP HANA Cloud
SAP Community, gcalixtosThe reasoningRunnable code
Core changed
SAP Business Application Studio – Using SAP HANA Tools with SAP Cloud Application Programming Model projects
SAP Community, Former MemberThe reasoningA recipeRunnable code
Core changed
My Learnings in SAP-CAP Using MongoDB
SAP Community, krish469The reasoningRunnable code
Gone quiet
Create an SAP Fiori Elements UI for CAP Node.js applications in SAP Business Application Studio
SAP Community, liat_bThe reasoning
nothing recorded
SAP Cloud Application Programming Model(CAP):概要およびデモ - Part 1
SAP Community, rasai, part 1 of 2
nothing recorded
Part 2: How to build an extension application for SAP S/4HANA Cloud using CAP, SAP Cloud SDK and SAP Fiori elements
SAP Community, former_member748, part 2 of 2The reasoningA recipeRunnable code
Core changed
First Java Cap Application
SAP Community, bruce_wang3
nothing recorded
Part 1: How to build an extension application for SAP S/4HANA Cloud using CAP, SAP Cloud SDK and SAP Fiori elements
SAP Community, former_member748, part 1 of 2The reasoningA recipeRunnable code
Core changed
Run and Deploy CAP with PostgreSQL on SAP BTP Cloud Foundry (Node.js)
SAP Community, Mike ZaschkaThe reasoningRunnable code
1 stale part
Random collection of useful code fragments for CAP Fiori Elements and SAPUI5
SAP Community, leoirudayamThe reasoningRunnable code
Core changed
Getting started with CAP on PostgreSQL (Node.js)
SAP Community, Mike ZaschkaThe reasoningRunnable code
1 stale part
SAP Fiori Element using CAP Model – List Report App
SAP Community, jhodel18The reasoning
nothing recorded
SAP Fiori Elements using CAP Model - Introduction
SAP Community, jhodel18The reasoning
nothing recorded
Developing a Fiori elements app with CAP and Fiori Tools
SAP Community, MioYasutakeThe reasoningA recipeRunnable code
Core changed
PostgreSQL persistence adapter for CAP (Node.js)
SAP Community, Volker BuzekThe reasoningRunnable code
Superseded
Developing Fiori Element Application (List Report and Object Page) consuming the OData service created using SAP Cloud Application Programming model
SAP Community, former_member187069The reasoningA recipe
Core changed
Introducing the Cloud Application Programming Model (CAP)
SAP Community, Daniel7
nothing recorded
Use SAP HANA as the Database for a CAP Java Application
SAP Developer Center, SAPThe reasoningA recipe
nothing recorded
Develop a Full-Stack CAP Application Following SAP BTP Developer's Guide
SAP Developer Center, SAPThe reasoningA recipe
nothing recorded

Details

Graph4 edges
POINTS OUT →
explainsDatabase connectorscapability, core and community
explainsFiori annotationscapability, core and community
published onSAP Communitypublishing source
discovered viaSAP Communitycap-tag
Source
Type
blog
Published on
Host
community.sap.com
First seen
History2
  • explains → applies_to on capability:database-connectors (cap); capability:fiori-annotations (cap)Door scope proposed from the title and summary, so a door page lists the piece only where it holds (docs/concepts/content-on-doors.md).
  • Entered the atlasDiscovered via SAP Community · cap-tag.
For your agent
Ref
content:upload-data-from-excel-in-cap-nodejs
JSON
/content/upload-data-from-excel-in-cap-nodejs.json
MCP
Connecting an agent