JCoDog - Webhook | Stripe Developers | Page 1

onyx axle Mar 2, 2022, 7:05 PM

#

Can you describe what is not working?

smoky bloom Mar 2, 2022, 7:06 PM

#

That is what I am not sure about, I ran the checkout and did the payment, but no webhook event was sent

#

#

The checkout code.

#

Everything works up to the payment then nothing.

#

and webhook code.

onyx axle Mar 2, 2022, 7:08 PM

#

When you look in your Event logs in the dashboard, what events do you see?

smoky bloom Mar 2, 2022, 7:09 PM

#

onyx axle Mar 2, 2022, 7:10 PM

#

Your webhook is only configured to listen to two events. What events are those?

smoky bloom Mar 2, 2022, 7:10 PM

#

success and failure

onyx axle Mar 2, 2022, 7:10 PM

#

Of what?

smoky bloom Mar 2, 2022, 7:10 PM

#

payment

#

onyx axle Mar 2, 2022, 7:11 PM

#

Yeah that's not what will get triggered here. HEre's a list of all Stripe events. Take a look as there are likely better ones that apply here
https://stripe.com/docs/api/events/types

smoky bloom Mar 2, 2022, 7:12 PM

#

What is being triggered by the checkout session?

#

checkout.session.completed?

onyx axle Mar 2, 2022, 7:13 PM

#

One of the best ways to test this out is to use stripe listen

#

https://stripe.com/docs/cli/listen

#

Personally I use this all the time

#

Because I can walk through testing a checkout session and then see, in real time, all the events that are triggered.

smoky bloom Mar 2, 2022, 7:14 PM

#

#

Would the vscode extension be where that is best?

#

checkout.session.completed did not trigger the endpoint either

onyx axle Mar 2, 2022, 7:17 PM

#

Did you change the events your endpoint is listening to?

#

And I would just run stripe listen in a terminal window and watch the events stream in

smoky bloom Mar 2, 2022, 7:17 PM

#

ok

smoky bloom Mar 2, 2022, 7:21 PM

#

onyx axle And I would just run `stripe listen` in a terminal window and watch the events s...

This came up and I did change the event that is being listened to

#

No webhook ran

onyx axle Mar 2, 2022, 7:23 PM

#

Okay so those are webhooks, using Stripe listen.

smoky bloom Mar 2, 2022, 7:24 PM

#

Yes but why is the webhook dash not showing them?

onyx axle Mar 2, 2022, 7:24 PM

#

Are you running this is test mode?

#

Is your webhook running in test mode?

smoky bloom Mar 2, 2022, 7:25 PM

#

yes all test mode

onyx axle Mar 2, 2022, 7:26 PM

#

Can you share the ID of your webhook?

smoky bloom Mar 2, 2022, 7:26 PM

#

we_1KHOm8EOJsqRXL0RoL6OCrNm

onyx axle Mar 2, 2022, 7:29 PM

#

Thanks, taking a look

smoky bloom Mar 2, 2022, 7:29 PM

#

Will I have this issue when I use the live one later?

onyx axle Mar 2, 2022, 7:31 PM

#

Okay I just logged in as you and I can see the 3 checkout.session.completed events for this webhook

smoky bloom Mar 2, 2022, 7:32 PM

#

then IDK because this should have updated...

#

#

[02-Mar-2022 19:15:48 UTC] Stripe Notice: Undefined property of Stripe\LineItem instance: data
[02-Mar-2022 19:17:43 UTC] Stripe Notice: Undefined property of Stripe\LineItem instance: data
[02-Mar-2022 19:20:11 UTC] Stripe Notice: Undefined property of Stripe\LineItem instance: data

#

onyx axle Mar 2, 2022, 7:34 PM

#

Okay, that is a different question.

#

So, in this case you are getting completed checkout sessions. And now you are saying that your account balance is not reflecting the amount in the Session?

smoky bloom Mar 2, 2022, 7:34 PM

#

yes

#

and the errors from the webhook being handles say line_items->data is not a thing

#

or even session

#

I built it from this guide but it says that data is not defined

onyx axle Mar 2, 2022, 7:41 PM

#

Well this guide is using a payment intent. If you responded to the payment_intent.succeeded event, you would be getting the payment intent in your webhook event.

#

In this case your object is different. The first thing I would do is try to convert the object to JSON and print it out so you can examine the shape.

smoky bloom Mar 2, 2022, 7:45 PM

#

Please check event ID evt_1KYy6HEOJsqRXL0R96Yrh0a9

#

Is this why?

#

The error log shows nothing new

onyx axle Mar 2, 2022, 7:46 PM

#

Okay, right. There are no line items on that object

#

So trying to access them should result in a key error

smoky bloom Mar 2, 2022, 7:47 PM

#

I am seeing it

onyx axle Mar 2, 2022, 7:47 PM

#

In the event response?

smoky bloom Mar 2, 2022, 7:47 PM

#

yes

#

it returns the checkout session id that then has the line items that I am getting

onyx axle Mar 2, 2022, 7:48 PM

#

Right, because you turn around and retrieve it again.

smoky bloom Mar 2, 2022, 7:49 PM

#

yes

#

onyx axle Mar 2, 2022, 7:49 PM

#

So, after you retrieve it, can you try printing out the JSON just to verify the shape of the object?

smoky bloom Mar 2, 2022, 7:49 PM

#

how would I do that because I dont view the page that the webhook is on

onyx axle Mar 2, 2022, 7:51 PM

#

I mean, in your code. when you return $checkout, try putting an echo $checkout in there to see what is happening.

smoky bloom Mar 2, 2022, 7:51 PM

#

Yes but that is in the webhook page...

#

I wont see the echo

#

the user is returned to a success page and the webhook runs on another page in the background on the server

onyx axle Mar 2, 2022, 7:53 PM

#

This is why I would suggest using stripe listen to forward the event to a localhost endpoint where you can test this out and log the objects.

smoky bloom Mar 2, 2022, 7:54 PM

#

#

for checkout

#

[02-Mar-2022 19:53:10 UTC] Stripe Notice: Undefined property of Stripe\LineItem instance: data

zenith vale Mar 2, 2022, 7:56 PM

#

line_items is an includable attribute of the checkout session, it is not included by default in API requests unless you request it with expansion, ie expand[]=line_items
https://stripe.com/docs/api/expanding_objects
https://stripe.com/docs/api/checkout/sessions/object#checkout_session_object-line_items

Stripe API reference – Expanding Responses – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

Stripe API reference – The Session object – curl

Complete reference documentation for the Stripe API. Includes code snippets and examples for our Python, Java, PHP, Node.js, Go, Ruby, and .NET libraries.

smoky bloom Mar 2, 2022, 7:57 PM

#

zenith vale Mar 2, 2022, 7:57 PM

#

Expansion is not supported/performed on webhook events, so this will never be included

#

If you need the session line_items you'll need to explicitly retrieve the session from the API after you receive the event

#

(and include the above-noted expansion in the request)

smoky bloom Mar 2, 2022, 7:57 PM

#

I have done that

zenith vale Mar 2, 2022, 7:57 PM

#

OK

smoky bloom Mar 2, 2022, 7:58 PM

#

smoky bloom

This was talked about a few hours ago when i couldnt get the checkout to work

zenith vale Mar 2, 2022, 7:58 PM

#

Apologies, i thought i reviewed the conversation and did not see that -- my mistake

smoky bloom Mar 2, 2022, 7:58 PM

#

previous support issue from this morning...

#

But the code has been said that I know that I have retrieved the right checkout session by putting it to echo out.

#

This is what was found in checkout

zenith vale Mar 2, 2022, 8:00 PM

#

smoky bloom [02-Mar-2022 19:53:10 UTC] Stripe Notice: Undefined property of Stripe\LineItem ...

What call leads to this error/warning?

smoky bloom Mar 2, 2022, 8:00 PM

#

zenith vale Mar 2, 2022, 8:01 PM

#

Right, but that's the raw json structure

#

Can you echo out line_items from the parsed object?

smoky bloom Mar 2, 2022, 8:03 PM

#

yes

#

evt_1KYyETEOJsqRXL0RfzisbkW7

#

    "object": "list",
    "data": [
        {
            "id": "li_1KYyEMEOJsqRXL0RlnViLP57",
            "object": "item",
            "amount_subtotal": 200,
            "amount_total": 200,
            "currency": "gbp",
            "description": "JCoNet Credits",
            "price": {
                "id": "price_1KH7rtEOJsqRXL0RUDVDJU5c",
                "object": "price",
                "active": true,
                "billing_scheme": "per_unit",
                "created": 1641997925,
                "currency": "gbp",
                "livemode": false,
                "lookup_key": null,
                "metadata": [],
                "nickname": "1500 credits",
                "product": "prod_Kx1vkcIuKc2pah",
                "recurring": null,
                "tax_behavior": "exclusive",
                "tiers_mode": null,
                "transform_quantity": {
                    "divide_by": 1500,
                    "round": "up"
                },
                "type": "one_time",
                "unit_amount": 200,
                "unit_amount_decimal": "200"
            },
            "quantity": 1500
        }
    ],
    "has_more": false,
    "url": "\/v1\/checkout\/sessions\/cs_test_b17cnmPJ1EfhOfkUVUFNFluKzBF0GfaNz2lGLlmugr9U5b17SiEFYtSAT9\/line_items"
}<br />
<b>Warning</b>:  Array to string conversion in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>54</b><br />
Array<br />
<b>Warning</b>:  Attempt to read property "id" on string in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>58</b><br />
<br />
<b>Warning</b>:  Undefined array key 0 in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>63</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>63</b><br />
<br />
<b>Warning</b>:  Undefined variable $_SESSION in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>73</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on value of type null in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>73</b><br />
<br />
<b>Warning</b>:  Attempt to read property "quantity" on null in <b>/home/u201085483/domains/jconet.co.uk/public_html/resources/webhooks/payments.php</b> on line <b>73</b><br />
Received unknown event type checkout.session.completed```Response to the webhook

zenith vale Mar 2, 2022, 8:07 PM

#

OK, let me try to test this a moment

smoky bloom Mar 2, 2022, 8:07 PM

#

ok

#

Do you need the full webhook code?

#

switch ($event->type) {
  case 'checkout.session.completed':
    $session = $event->data->object;
    $checkout = $stripe->checkout->sessions->retrieve(
      $session->id,
      ['expand' => ['line_items']]
    );
    echo $checkout->line_items;
    $items = $checkout->line_items->data;
    foreach ($items as $item) {
      if ($item->price->product == 'prod_Kx1vkcIuKc2pah') {
        // add credits to the user
        $custID = $checkout->customer->id;

        $result = mysqli_query($conn, "SELECT ID FROM customers WHERE stripeID ='".$custID."'");
        $customerDB = mysqli_fetch_all($result, MYSQLI_ASSOC);

        $balResult = mysqli_query($conn, "SELECT * FROM credits WHERE userID ='".$customerDB[0]['ID']."'");
        $num_rows = mysqli_num_rows($balResult);
        $creditDB = mysqli_fetch_all($balResult, MYSQLI_ASSOC);

        if ($num_rows > 0) {
          // update
          $bal = $creditDB[0]['creditBalance']+$item->data->quantity;
          mysqli_query($conn, "UPDATE credits SET creditBalance=".$bal);
        } else {
          // insert
          mysqli_query($conn, "INSERT INTO credits SET userID=".$_SESSION['userID'].", creditBalance=".$item->data->quantity);
        }
      };
    };
  // ... handle other event types
  default:
    echo 'Received unknown event type ' . $event->type;
}```

smoky bloom Mar 2, 2022, 8:26 PM

#

is there any clue why this is happening because i cant see why line_items->data is undefined

zenith vale Mar 2, 2022, 8:29 PM

#

Still working to test 🙂

smoky bloom Mar 2, 2022, 8:29 PM

#

Ok thanks. let me know I am going to work on setting up subscriptions. 🙂

zenith vale Mar 2, 2022, 8:29 PM

#

👍

zenith vale Mar 2, 2022, 9:28 PM

#

Was having some issues with my PHP environment but this all works as expected for me:

$sessionWithItems = $stripe->checkout->sessions->retrieve(
        $session -> id,
        ['expand' => ['line_items']]
      );

    echo count($sessionWithItems -> line_items);
    echo $sessionWithItems -> line_items->data[0];
    $items = $sessionWithItems -> line_items -> data;
    foreach($items as $item) {
        echo $item -> price -> product;
    }

#

What version of the library are you using?

#

I think your error is coming from another place:
$bal = $creditDB[0]['creditBalance']+$item->data->quantity;

#JCoDog - Webhook