DOMException: Invalid Character Error in file /vendor/spatie/array-to-xml/src/ArrayToXml.php on line 42

[mattlake]

I am trying to return a collection as xml using the following code snippet:

$data = Order::all();
return response()->xml($data);

However, I am getting the following response:
DOMException: Invalid Character Error in file /vendor/spatie/array-to-xml/src/ArrayToXml.php on line 42

I am using the following versions:
response-xml: ^2.0
Laravel Framework: ^8.40
PHP: 8.0.5

Have I made a silly mistake somewhere?

[mattlake]

Interestingly, if I break the data down myself and manually create the response array that seems to work.

Calling ->toArray() on the collection didn't though

[arnedeutscher]

It´s because you can´t use an element name start with number. As you have already done correctly, you have to change the array manually and change each iterator from 0 to, '_0'.

[YogeshwarDBarai]

I finally got the solution for this issue ,while using eloquent query as shown below

$user= Sample::all();

then your response code should look like this
you can customize the users tag .
return response()->xml(['**users**' => $user->toArray()]);

output is as shown below

<response>
      <users>
            <id>1</id>
            <name>John</name>
            <age>23</age>
            <city>Mumbai</city>
      </users>
      <users>
          <id>2</id>
          <name>Doe</name>
          <age>25</age>
          <city>Delhi</city>
      </users>
</response>

I am trying to return a collection as xml using the following code snippet:

$data = Order::all();
return response()->xml($data);

However, I am getting the following response: DOMException: Invalid Character Error in file /vendor/spatie/array-to-xml/src/ArrayToXml.php on line 42

I am using the following versions: response-xml: ^2.0 Laravel Framework: ^8.40 PHP: 8.0.5

Have I made a silly mistake somewhere?

[YogeshwarDBarai]

It´s because you can´t use an element name start with number. As you have already done correctly, you have to change the array manually and change each iterator from 0 to, '_0'.

please refer above to avoid manual changing , i hope this helps