# Convert (JSON to CSV) / Testing is broken

**URL:** <https://community.activepieces.com/t/convert-json-to-csv-testing-is-broken/3288>\
**Category:** Known Issues\
**Created:** [February 28, 2024, 5:13pm UTC](https://community.activepieces.com/t/convert-json-to-csv-testing-is-broken/3288 "2024-02-28T17:13:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cumonvip](https://community.activepieces.com/user_avatar/community.activepieces.com/cumonvip/32/1796_2.png) [@Cumonvip](https://community.activepieces.com/u/Cumonvip)\
**Post date:** [February 28, 2024, 5:13pm UTC](https://community.activepieces.com/t/convert-json-to-csv-testing-is-broken/3288/1 "2024-02-28T17:13:19Z")

</div>

For it is not able to test a block

I always got the error message: **CSV JSON is not a valid JSON object.**

 ![grafik](https://community.activepieces.com/uploads/default/original/2X/4/40bb4efaa1f64679422fc2f52738ed848ed15716.png)

I also tried to test with the direct JSON Code - but the “Test” Button is not clickable.

JSON:

```auto
{
  "events": [
    {
      "idEvent": "1841123",
      "idSoccerXML": null,
      "idAPIfootball": "1048881",
      "strEvent": "Werder Bremen vs Bayern Munich",
      "strEventAlternate": "Bayern Munich @ Werder Bremen",
      "strFilename": "German Bundesliga 2023-08-18 Werder Bremen vs Bayern Munich",
      "strSport": "Soccer",
      "idLeague": "4331",
      "strLeague": "German Bundesliga",
      "strSeason": "2023-2024",
      "strDescriptionEN": "",
      "strHomeTeam": "Werder Bremen",
      "strAwayTeam": "Bayern Munich",
      "intHomeScore": "0",
      "intRound": "1",
      "intAwayScore": "4",
      "intSpectators": null,
      "strOfficial": "",
      "strTimestamp": "2023-08-18T18:30:00+00:00",
      "dateEvent": "2023-08-18",
      "dateEventLocal": "2023-08-18",
      "strTime": "18:30:00",
      "strTimeLocal": "20:30:00",
      "strTVStation": null,
      "idHomeTeam": "133662",
      "idAwayTeam": "133664",
      "intScore": "10",
      "intScoreVotes": "1",
      "strResult": "",
      "idVenue": null,
      "strVenue": "wohninvest WESERSTADION",
      "strCountry": "Germany",
      "strCity": "",
      "strPoster": "https://www.thesportsdb.com/images/media/event/poster/ym7izp1688635848.jpg",
      "strSquare": "",
      "strFanart": null,
      "strThumb": "https://www.thesportsdb.com/images/media/event/thumb/mc87g21688630570.jpg",
      "strBanner": "",
      "strMap": null,
      "strTweet1": "",
      "strTweet2": "",
      "strTweet3": "",
      "strVideo": "https://www.youtube.com/watch?v=RiU6s76b0Ug",
      "strStatus": "Match Finished",
      "strPostponed": "no",
      "strLocked": "unlocked"
    },

```

Is this a known bug or can you help me @Community@abuaboud@kanarelo

---

<div class="post-metadata">

**Author:** ![Bram](https://community.activepieces.com/user_avatar/community.activepieces.com/bram/32/2705_2.png) [@Bram](https://community.activepieces.com/u/Bram)\
**Post date:** [February 28, 2024, 7:20pm UTC](https://community.activepieces.com/t/convert-json-to-csv-testing-is-broken/3288/2 "2024-02-28T19:20:43Z")

</div>

Hi @Cumonvip,

JSON formatting is in base always the same, you have to start with curly opening en closing brackets. And within the JSON body u have a “key” and a “value”. Also notice that apostrophes need to be straight as you see above they are formatted as opening and closing apostrophes so don’t copy anything from below but tripe over or change the apostrophes. Also keep in mind that every row end with a comma except the last! And also not when there is just one row.

{  
“Key1”:”value1”,  
“Key2”:”value2”,  
“Key3”:”value3”  
}

I hope this helps you further!

Also the data you copied as JSON, misses the closing brackets, that probably why it does not see it as valid JSON

---

<div class="post-metadata">

**Author:** ![Cumonvip](https://community.activepieces.com/user_avatar/community.activepieces.com/cumonvip/32/1796_2.png) [@Cumonvip](https://community.activepieces.com/u/Cumonvip)\
**Post date:** [February 28, 2024, 8:39pm UTC](https://community.activepieces.com/t/convert-json-to-csv-testing-is-broken/3288/3 "2024-02-28T20:39:01Z")

</div>

@Bram  
Thanks so much! This works for me!

---

<div class="post-metadata">

**Author:** ![system](https://community.activepieces.com/uploads/default/original/1X/f3af8cd75e0cc52ac7f19a3b45663ce0396f5016.png) [@system](https://community.activepieces.com/u/system)\
**Post date:** [February 29, 2024, 8:39pm UTC](https://community.activepieces.com/t/convert-json-to-csv-testing-is-broken/3288/4 "2024-02-29T20:39:34Z")

</div>

Closed on February 29, 2024, 8:39pm UTC

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
