Solved: Get Data from WEB returning Details: "We found ext... - Page 2

haze · ‎12-26-2017

Hi,

I am getting error on Unable to connect when I am tyring to Get Data from WEB (Basic URL: <Gerrit REST api url that I wanted to access to>).

And when I tried to validate the JSON format of my query, I noticed that there are some unexpected characters as shown below before the JSON content start.

)]}'
[
  [
    { <JSON CONTENT start here>

I am not sure whether is that the cause of why I am not able to get data from web successfully.

Would be great if anyone of you can teach me a way to get rid of the unwanted character so that I can use the get data from web feature.

Thanks. Looking forward for the recomendation.

Cheers.. Happy New Year in advance!~

v-yuezhe-msft · ‎12-28-2017

@haze,

Removing )]}' from your JSON file, I can successfully import data from the JSON file to Power BI Desktop. It seems that your web generates a invalid JSON file.

[
{
"id": "isg_es-sy_repo-a~master~Icb88a96142678a678562eb051eed9b4002b154ee",
"project": "isg_es-sy_repo-a",
"branch": "master",
"hashtags": [],
"change_id": "Icb88a96142678a678562eb051eed9b4002b154ee",
"subject": "Testing as reviewer",
"status": "NEW",
"created": "2017-10-12 05:54:52.473000000",
"updated": "2017-10-12 05:54:52.473000000",
"mergeable": true,
"insertions": 3,
"deletions": 1,
"_number": 18737,
"owner": {
"_account_id": 1000295
}
},
{
"id": "isg_es-sy_repo-a~master~I2c90d3229402a53eb5510fcfacd60bba5f4a495c",
"project": "isg_es-sy_repo-a",
"branch": "master",
"hashtags": [],
"change_id": "I2c90d3229402a53eb5510fcfacd60bba5f4a495c",
"subject": "Testing for Siong Yee as reviewer",
"status": "NEW",
"created": "2017-10-12 05:52:25.797000000",
"updated": "2017-10-12 05:52:25.797000000",
"mergeable": true,
"insertions": 3,
"deletions": 1,
"_number": 18736,
"owner": {
"_account_id": 1006467
}
},
{
"id": "isg_es-sy_repo-a~master~I6c5a54c626bac6b2edea4905351f8ec456458567",
"project": "isg_es-sy_repo-a",
"branch": "master",
"hashtags": [],
"change_id": "I6c5a54c626bac6b2edea4905351f8ec456458567",
"subject": "test",
"status": "NEW",
"created": "2017-10-12 05:47:12.519000000",
"updated": "2017-10-12 05:47:12.519000000",
"mergeable": false,
"insertions": 2,
"deletions": 1,
"_number": 18735,
"owner": {
"_account_id": 1000295
}
},
{
"id": "isg_es-sy_repo-a~master~I1e303fc074169531c939e29fe2d76b95e018c262",
"project": "isg_es-sy_repo-a",
"branch": "master",
"hashtags": [],
"change_id": "I1e303fc074169531c939e29fe2d76b95e018c262",
"subject": "Testing",
"status": "NEW",
"created": "2017-10-12 05:43:21.776000000",
"updated": "2017-10-12 05:43:21.776000000",
"mergeable": false,
"insertions": 3,
"deletions": 1,
"_number": 18734,
"owner": {
"_account_id": 1006467
}
},
{
"id": "isg_es-sy_repo-a~master~Ic53892568c4dd31167cdc24f725676dec413a5d3",
"project": "isg_es-sy_repo-a",
"branch": "master",
"hashtags": [],
"change_id": "Ic53892568c4dd31167cdc24f725676dec413a5d3",
"subject": "Merge branch \u0027master\u0027 isg_es-sy_repo-a",
"status": "NEW",
"created": "2017-10-12 05:40:58.000000000",
"updated": "2017-10-12 05:40:58.000000000",
"mergeable": true,
"insertions": 0,
"deletions": 0,
"_number": 18733,
"owner": {
"_account_id": 1000295
}
},
{
"id": "isg_es-sy_repo-a~master~I8eb5f0f80ca7674f4eb1fb2d9eb0ef3c4f704b44",
"project": "isg_es-sy_repo-a",
"branch": "master",
"hashtags": [],
"change_id": "I8eb5f0f80ca7674f4eb1fb2d9eb0ef3c4f704b44",
"subject": "fail to push- no sign-of-by",
"status": "NEW",
"created": "2017-10-12 05:08:23.163000000",
"updated": "2017-10-12 05:08:23.163000000",
"mergeable": true,
"insertions": 2,
"deletions": 1,
"_number": 18732,
"owner": {
"_account_id": 1000295
}
}
]

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Get Data from WEB returning Details: "We found extra characters at the end of JSON input."

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024