Http response "->json()" returns null, "->body()" contains data

It looks like you're encountering an issue where the ->json() method is returning null, even though the ->body() method shows that the response contains valid JSON data. This can happen if the JSON response is not properly formatted or if there are hidden characters that are causing the JSON parsing to fail.

Here are a few steps to troubleshoot and resolve this issue:

1. Check for Hidden Characters: Sometimes, hidden characters (like BOM - Byte Order Mark) can cause JSON parsing to fail. You can use trim() to remove any such characters.

2. Validate JSON Format: Ensure that the JSON response is properly formatted. You can use an online JSON validator to check the format.

3. Manually Decode JSON: If the ->json() method is not working, you can manually decode the JSON response using json_decode().

Here is an example of how you can manually decode the JSON response:

$response = Http::baseUrl('http://example.com')
    ->withHeaders(['DBName' => 'my-db-name'])
    ->get('/the-endpoint');

$body = $response->body();
$jsonData = json_decode($body, true);

if (json_last_error() === JSON_ERROR_NONE) {
    // Successfully decoded JSON
    var_dump($jsonData);
} else {
    // JSON decoding failed
    echo 'JSON Error: ' . json_last_error_msg();
}

In this example, we first get the response body using ->body(), then manually decode it using json_decode(). We also check for any JSON decoding errors using json_last_error() and json_last_error_msg().

If the manual decoding works, it indicates that there might be an issue with how the ->json() method is handling the response. If you continue to face issues, you might want to inspect the raw response headers and body to ensure there are no anomalies.

Additionally, you can try adding the Accept header explicitly to ensure the server returns JSON:

$response = Http::baseUrl('http://example.com')
    ->withHeaders([
        'DBName' => 'my-db-name',
        'Accept' => 'application/json'
    ])
    ->get('/the-endpoint');

$jsonData = $response->json();

if ($jsonData === null) {
    // Fallback to manual decoding if ->json() returns null
    $body = $response->body();
    $jsonData = json_decode($body, true);
}

var_dump($jsonData);

By explicitly setting the Accept header, you ensure that the server knows you expect a JSON response. If ->json() still returns null, the manual decoding fallback will handle the response.