data at the root level is invalid. line 1 position 1

Dynamics 365 Business Central/NAV Developers Forum
1

Hi All,

I have made the XML Port to upload the item, i just got this error data at the root level is invalid. line 1 position 1,

Any idea how to resolve it.

Navision 2009 SP1 (RTC)

Regards,
shailesh

2

Hi Shailesh,

see which field you select in Node Name, Any space between the any fields

3

are you importing data in the item table?

4

Hi Avinash,

Iam importing the data.

Below are the feild which iam using in xmlport

Node Name Node Type Source Type Data Source
Item Element Table (Item)
No. Element Field Item::No.
No._2 Element Field Item::No. 2
Description Element Field Item::Description
Description_2 Element Field Item::Description 2
5

which file you want to import that is in xml format or exel?

6

In Excel format , CSV format.

7

Did you try by removing .and_ from Node names?

8

yes i have try by removing . and _ form node names?

but still the same error.

9

Check XMLPort 5900 in standard Database and add Root element

10

Hi, did you get the answer of above problem?

Plesae share .

Regards,

Nitin

11

Did you try this suggestion?

12

In XMLPort Properties select format as “Variable Text” In Place of “XML”

13

Dear All,

While Importing Getting Same Error. Please Give Me Solution

Data at the root level is invalid. line 1 position 1,

14

Did you try the suggestion that Murali Mohan offered? It sounds like your xmlport is expecting a file that’s formatted in XML, but you’re feeding it a file formatted to csv standards. Could that possibly be the problem?

15

Thanks alot it worked…[:D]

All you buddies out there are amazingly awesome.…