Read Excel file content after rest call API with tFileInputRaw

LNYAKA1625749060 — Fri, 15 Nov 2024 23:57:25 GMT

Hello everybody,

I called an api rest (get method) which sends me back a json response containing the information of the excel file that I will read the data.

The form of this json file is the following

{

"entry":{

"isFile":true,

"createdByUser":{

"id":"trestTATA",

"displayName":"Helen Marc"

"modifiedAt":"2020-04-11T08:21:43.904+0000",

"nodeType":"cm:content",

"content":{

"mimeType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",

"mimeTypeName":"Microsoft Excel 2007",

"sizeInBytes":3396,

"encoding":"UTF-8"

"parentId":"bcb4390c-006c-44cd-b526-0d240859bca2",

"aspectNames":[

"rn:renditioned",

"cm:versionable",

"cm:auditable",

"cm:thumbnailModification",

"ged:attributs"

"createdAt":"

2020-04-11T08:21:43.904+0000

"isFolder":false,

"modifiedByUser":{

"id":"trestTATA",

"displayName":"Helen Marc"

"name":"EMPLOYEE.xlsx",

"id":"7lk4578-4175-4e9f-8465-26bc784512c",

"properties":{

"ged:entite":"MERTA",

"cm:versionType":"MAJOR",

"ged:filiere":"N/A",

"cm:versionLabel":"1.0",

"cm:lastThumbnailModification":[

"doclib:1626079366562"

]

}

This excel file contains a column named salary and containing several salary lines.

How can I read the content of my excel file with tFileInputRaw

Re: Read Excel file content after rest call API with tFileInputRaw

Anonymous — Wed, 14 Jul 2021 12:10:43 GMT

Why don't you use tFileInputExcel to read the Excel file?

Re: Read Excel file content after rest call API with tFileInputRaw

LNYAKA1625749060 — Wed, 14 Jul 2021 12:14:23 GMT

My excel fil is located in server and the file contains a id . I must call a api rest to get the file excel.

topic Read Excel file content after rest call API with tFileInputRaw in Talend Studio

Read Excel file content after rest call API with tFileInputRaw

Re: Read Excel file content after rest call API with tFileInputRaw

Re: Read Excel file content after rest call API with tFileInputRaw