Add email address in Console or Model?

[mcconnon12]

I was wondering if there was something I could add to the Console or Model on Orders to have the email address pass through? Currently the email does not come through. This would make my life so much easier with connecting to my ESP.

[ericingram]

How about expanding the account on request?

[mcconnon12]

Can you expand on that for me? Thanks.

[ericingram]

How are you getting the order in this case? If fetching via console or API, you can expand the account to get the email like this:

GET /orders/{id}
{
  "expand": "account"
}

[mcconnon12]

I would be using the Pabbly Connect Swell App. If I add this in the console would automatically expand to grab the email address on all future orders?

[ericingram]

I'm not familiar with the app so I can't say, but in general that's how you would get an email along with an order in the same request.

[mcconnon12]

Pretty sure it's just a webhook. Is there something I can add to the model in the Developer section to just relay the email in the initial webhook?

[ericingram]

Ah I see. The webhook response just returns the object by itself (an order) and you would have to make a subsequent request to get more data. We've considered adding a configurable query to webhooks that would allow you to include more data in the response and this is an interesting data point.

One way to accomplish this would be to create a formula field for the account email on the order model.

PUT /:models/orders/fields
{
  "account_email": {
    "type": "string",
    "formula": "account.email"
   }
}

However keep in mind that formulas are only executed when an order is created or updated. If the customer changes their email in the meantime, the order would have an old email value until it was updated. Still it should solve your problem with an order create or update webhook.

[mcconnon12]

Boom! Just tested this and it seems to be working. This has been a huge thorn in my side... thank you!! Great point... on if they update their email at some point... Is there something similar I can do to capture that as well?

[ericingram]

Glad to hear it!

A webhook for account.updated would be sent in that case, but not sure how Pabbly handles it

[mcconnon12]

Hey Eric, I take it if I wanted to do this for abandoned carts it would be:

PUT /:models/carts/fields
{
"account_email": {
"type": "string",
"formula": "account.email"
}
}

I appreciate the help.

[ericingram]

Yes, that's correct.

Also with Swell Apps in alpha, you could solve this in another way with app function to listen to those events and then send your own payload, with account email or other data, directly to Pabbly. Would be nice to see a Pabbly app in the marketplace at some point of course.