I am trying to convert github raw data to JSON but unfortunately I am not able to do that. I am using reactJs My Code:
fetch("https://api.github.com/repos/graphql-compose/graphql-compose-examples/contents/examples/northwind/data/csv/employees.csv")
.then((res) => {
if (res.ok) {
return res.content; // need to convert this content to json
} else {
throw new Error("Something went wrong");
}
})
.then((data) => console.log(data))
.catch((error) => {
console.log(error);
});
You can call json() on the response. See "basic fetch request" example here.
The content property contains a base64 encoded value but it also contains line breaks which have to be removed before you're able to convert using atob. Afterwards, you get CSV lines:
fetch("https://api.github.com/repos/graphql-compose/graphql-compose-examples/contents/examples/northwind/data/csv/employees.csv")
.then(res => res.json())
.then(data => console.log(atob(data.content.replace('\n', ''))))
Output:
employeeID,lastName,firstName,title,titleOfCourtesy,birthDate,hireDate,address,city,region,postalCode,country,homePhone,extension,photo,notes,reportsTo,photoPath
1,Davolio,Nancy,Sales Representative,Ms.,1948-12-08 00:00:00.000,1992-05-01 00:00:00.000,507 20th Ave. E. Apt. 2A,Seattle,WA,98122,USA,(206) 555-9857,5467,0x151C2F00020000000D000E0014002100FFFFFFFF4269746D617020496D616765005061696E742E506963747572650001050000020000000700000050427275736800000000000000000020540000424D20540000000000007600000028000000C0000000DF0000000100040000000000A0530000CE0E0000D80E0000000000,Education includes a BA in psychology from Colorado State University in 1970. She also completed The Art of the Cold Call. Nancy is a member of Toastmasters International.,2,http://accweb/emmployees/davolio.bmp
...