To merge two fields, such as the first name and last name, use a double underscore (_) in the respective value in the "keys" array. This will automatically fetch the value of "name" and include it in the exported CSV. For instance, if you have an object that has an object inside it, and that object has another object inside it, you can simply get the value you want by using dot notation (e.g., ). Since JSON data can be deeply nested, you can traverse the path to the value you want to use by separating it with a dot. In the example above, we have an array of profiles that we want to transform into a CSV file. Here the piece of code that does the fetch request file in my script.Import Explanation So, for the second part of this tutorial we are going to use fetch to read the excel file and convert the data result to JSON. Fetch also provides a single logical place to define other HTTP-related concepts such as CORS and extensions to HTTP. It also provides a global fetch() method that provides an easy, logical way to fetch resources asynchronously across the network. The Fetch API provides a JavaScript interface for accessing and manipulating parts of the HTTP pipeline, such as requests and responses. Most of those browsers now support the Fetch API, which is a modern way to Ajax without helper libraries like jQuery or Axios. In the last recent years, browsers have improved so much (except Internet Explorer to my opinion). So Let’s go ahead and add the XLSX library dependency from its content delivery network js (CDNjs) in the “head tag” of my index.html file: Using Fetchįor learning purpose let’s explore another method to Ajax. This JavaScript plugin works in web browsers and servers. We are going to use SheetJS js-xlsx ( Spreadsheets simplified) to read and process the excel file. Here the piece of code that makes the call and display data using Jquery append method:Ījax call that read the CSV file | converts data to JSON | display data on the list HTML Now inside my script.js file, I’m making an Ajax call to read the CSV file, convert the data result to JSON, and display it in a list on the HTML page. Initiating an Ajax call through “jQuery’s Ajax method” is one the easiest way available. We could do Ajax without jQuery, but we had to write an XMLHttpRequest Which is a bit more complex and complicated. Whenever we send or retrieve information with JavaScript, we initiate a thing known as an Ajax call. It allows browsers to send and retrieve information, then does things with what it gets back, like add or change HTML on the page.” “Ajax is a technique to send and retrieve information behind the scenes without needing to refresh the page. Note: On the very top of my script, I have declared API variables that are the link the CSV and Excel files inside my project folder: var csv_file_API = './UsersSample.csv' var excel_file_API = './soccer_players.xlsx' Using Ajax
0 kommentar(er)
