Mam stworzony endpoint w postaci JSON , korzystając z tego poradnika https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/
No i teraz mam swój endpoint ale za nic w świecie nie wiem jak teraz dodać dane
Próbuje dodać następująco:
{
"feed":
{
"entry": [
{
"content": {
"type":"text",
"$t":"wiersz231231"
}
}
]
}
}
ale to nie działa, czy to błąd w składni czy kompletnie inaczej mam te dane wysyłać ?
sam endpoint prezentuja się następująco:
{"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$batch":"http://schemas.google.com/gdata/batch","xmlns$gs":"http://schemas.google.com/spreadsheets/2006","id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"Arkusz1"},"link":[{"rel":"alternate","type":"application/atom+xml","href":"https://docs.google.com/spreadsheets/u/0/d/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/pubhtml"},{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full"},{"rel":"http://schemas.google.com/g/2005#post","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full"},{"rel":"http://schemas.google.com/g/2005#batch","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/batch"},{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full?alt\u003djson"}],"author":[{"name":{"$t":"szac0000"},"email":{"$t":"szac0000@gmail.com"}}],"openSearch$totalResults":{"$t":"6"},"openSearch$startIndex":{"$t":"1"},"gs$rowCount":{"$t":"1000"},"gs$colCount":{"$t":"26"},"entry":[{"id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R1C1"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"A1"},"content":{"type":"text","$t":"wiersz1"},"link":[{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R1C1"}],"gs$cell":{"row":"1","col":"1","inputValue":"wiersz1","$t":"wiersz1"}},{"id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R1C2"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"B1"},"content":{"type":"text","$t":"11"},"link":[{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R1C2"}],"gs$cell":{"row":"1","col":"2","inputValue":"11","numericValue":"11.0","$t":"11"}},{"id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R2C1"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"A2"},"content":{"type":"text","$t":"wiersz2"},"link":[{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R2C1"}],"gs$cell":{"row":"2","col":"1","inputValue":"wiersz2","$t":"wiersz2"}},{"id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R2C2"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"B2"},"content":{"type":"text","$t":"22"},"link":[{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R2C2"}],"gs$cell":{"row":"2","col":"2","inputValue":"22","numericValue":"22.0","$t":"22"}},{"id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R3C1"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"A3"},"content":{"type":"text","$t":"wiersz3"},"link":[{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9dasdsxx/1/public/full/R3C1"}],"gs$cell":{"row":"3","col":"1","inputValue":"wiersz3","$t":"wiersz3"}},{"id":{"$t":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2sdasaxx1p9rbmlzz_MDBLTwBCgbv5CU/1/public/full/R3C2"},"updated":{"$t":"2020-05-10T15:31:51.748Z"},"category":[{"scheme":"http://schemas.google.com/spreadsheets/2006","term":"http://schemas.google.com/spreadsheets/2006#cell"}],"title":{"type":"text","$t":"B3"},"content":{"type":"text","$t":"33"},"link":[{"rel":"self","type":"application/atom+xml","href":"https://spreadsheets.google.com/feeds/cells/1QuWf_WoxF5ft2m5lh0C1p9rdasdaTwBCgbv5CU/1/public/full/R3C2"}],"gs$cell":{"row":"3","col":"2","inputValue":"33","numericValue":"33.0","$t":"33"}}]}}