Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ramonmata
New Member

Error encountered by JSON parser: Unterminated string

Hi,

I am having this problem when trying to add more than 9 "rows" in a single POST to the REST API, and which accordingly with the limitations that should not be a problem

 

https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

 

 

This is the error I am getting after the request data is sent:

 

{"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|01fecc15-5954-4c6b-bbb2-d89b29bc43ca: Error encountered by JSON parser: Unterminated string. Expected delimiter: \". Path 'rows[9].Cobertura', line 1, position 3780."}}

 

 Any ideas?

 

 

best regards,

Ramon

 

1 ACCEPTED SOLUTION
ramonmata
New Member

Nevermind.... I found the problem.

 

I was calculating wrong the content lenght for the request, falling on the short side, so the server never got the complete data and parser was correctly complaining!

 

 

regards

View solution in original post

2 REPLIES 2
ramonmata
New Member

Nevermind.... I found the problem.

 

I was calculating wrong the content lenght for the request, falling on the short side, so the server never got the complete data and parser was correctly complaining!

 

 

regards

ramonmata
New Member

Hi,

I am having this problem when trying to add more than 9 "rows" in a single POST to the REST API, and which accordingly with the limitations that should not be a problem

 

https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

 

 

This is the error I am getting after the request data is sent:

 

{"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|01fecc15-5954-4c6b-bbb2-d89b29bc43ca: Error encountered by JSON parser: Unterminated string. Expected delimiter: \". Path 'rows[9].Cobertura', line 1, position 3780."}}

 

 

And the json data I sent:

 

{"rows":[{"Aplicativo":"Educación a Distancia SIED","Coordinacion":"CSDISA","Coordinacion Tecnica":"CTSDIS","WBS":"1-0000011774-11","Division":"DSDIOH","Delivery Manager":"Rafael Salazar ","Service Manager":"Héctor Rodrigo Rangel Vargas","Esfuerzo Base":68.65,"UCOIs Base":0.42900000000000005,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Baja","FCFM":1.9285,"MXM":21619.91},{"Aplicativo":"ACCEDER","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":115.9,"UCOIs Base":0.7244,"Grupo":4,"Tecnologia":"Legado","Cobertura":"7X24","Criticidad":"Critica","FCFM":2.6999,"MXM":51101.61},{"Aplicativo":"Acceder Unificado","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":777.4,"UCOIs Base":4.8587,"Grupo":4,"Tecnologia":"Legado","Cobertura":"7X24","Criticidad":"Critica","FCFM":2.6999,"MXM":342773.87},{"Aplicativo":"Actualización Dato CURP","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":115.9,"UCOIs Base":0.7244,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Media","FCFM":2.117,"MXM":40068.93},{"Aplicativo":"ADIMSS","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"Sin WBS","Division":"Sin división","Delivery Manager":"Sin Delivery Manager","Service Manager":"Sin Service Manager","Esfuerzo Base":60.57,"UCOIs Base":0.3785,"Grupo":5,"Tecnologia":"Legado","Cobertura":"5x12","Criticidad":"Media","FCFM":1.99375,"MXM":19720.4},{"Aplicativo":"ADMIN","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSIIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Elizabeth Hernández López","Esfuerzo Base":777.4,"UCOIs Base":4.8587,"Grupo":5,"Tecnologia":"Legado","Cobertura":"5x12","Criticidad":"Baja","FCFM":2.918125,"MXM":370479.28},{"Aplicativo":"ADMIN SSO","Coordinacion":"CIT","Coordinacion Tecnica":"CTACVA","WBS":"1-0000011774-29","Division":"DACVASS","Delivery Manager":"Marco Antonio De la Cruz","Service Manager":"Sandra Meneses","Esfuerzo Base":60.57,"UCOIs Base":0.3785,"Grupo":1,"Tecnologia":"Multiplataforma","Cobertura":"7X24","Criticidad":"Critica","FCFM":3.85,"MXM":38080.770000000004},{"Aplicativo":"ADMPOS","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIPES","WBS":"1-0000011774-23","Division":"DSDPES","Delivery Manager":"María del Pilar Plaza Duarte","Service Manager":"Jatziry Eugenia De La Oca Vázquez","Esfuerzo Base":40.300000000000004,"UCOIs Base":0.2519,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Baja","FCFM":1.9285,"MXM":12691.17},{"Aplicativo":"ADO IMSS Digital","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSIIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Elizabeth Hernández López","Esfuerzo Base":60.57,"UCOIs Base":0.3785,"Grupo":1,"Tecnologia":"Multiplataforma","Cobertura":"7X24","Criticidad":"Critica","FCFM":5.1205,"MXM":50647.42},{"Aplicativo":"Alta Patronal Persona Física por CURP","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":0,"UCOIs Base":0,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Media","FCFM":0,"MXM":0}]}

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.