Stripe is not sharing enough information to create an invoice in Freshbooks

Status: Closed · Asked by Durkis on · 0 views

Durkis — Question ·

I think I am setting up the integration from the stripe side OK, notifications are being received when a stripe invoice is created, but when I go to the Freshbooks side of things, Stripe has not handed over the info sufficient to create a Freshbooks invoice. Name, email, even the amount, these fields are not there. Can I get this info from Stripe so that I can set up these events in Freshbooks?

Pabblymember11 — Reply ·

Hey @Durkis

Can I get this info from Stripe so that I can set up these events in Freshbooks?

Yes, you can fetch the related data from your Stripe with the help of the "Stripe: Retrieve a Customer by Email" action event, whereas you need to pass/map the email address from your trigger response to this action.

Kindly try this at your end and let us know if that works for you.

Durkis — Reply ·

Thanks. It works now, but instead of putting 50 cents in the cost field in the created invoice it's putting $50, I did not use mapping to enter the info,, I used the data object.

Durkis — Reply ·

Another point, the name is not recorded as separate first and last name. Is there a way to separate the first and last names into different fields to create a more accurate invoice ?

Pabblymember11 — Reply ·

Hey @Durkis

instead of putting 50 cents in the cost field in the created invoice it's putting $50, I did not use mapping to enter the info,, I used the data object.

For this, you can use the Number formatter to convert it decimal, please check out the following screenshot -

the name is not recorded as separate first and last name. Is there a way to separate the first and last names into different fields to create a more accurate invoice ?

For this, you can use the Text Formatter to split the text and can map the response further accordingly -

Durkis — Reply ·

Well you people have thought of everything, haven't you;) Thanks so much for your help, I'm getting the hang of this and it's very impressive.

Pabblymember11 — Reply ·
Well you people have thought of everything, haven't you;) Thanks so much for your help, I'm getting the hang of this and it's very impressive.

Thanks for your kind words. Please do share your feedback or anything else which we can improvise.

Do check our YouTube channel where we have more than 1000+ video tutorials - https://www.youtube.com/channel/UCVA5GKy8qpDxQR5xSt_zcJg

Durkis — Reply ·

Hey. sorry to bring this t you again. Upon deleting the retrieve customer by email step and trying to reinstate it, there is no email or purchase amount info being reported from the test transaction on stripe. can you help? The Data object amount captured field is not being provided and I cant even find an email

Attachments

Screenshot (102).png
Screenshot (103).png
Pabblymember11 — Reply ·

Hey @Durkis

We looked into your workflow and it seems like you have changed the previously used trigger event, so because of that, the mapping gets distorted.

To retrieve the Charge details from the triggering data of Stripe, the "New Charge " trigger event, doesn't provide the charge ID to retrieve the further details of the user.

If you want to retrieve the charge details you can use the "New Invoice" trigger event.

Durkis — Reply ·

Got it working again, thanks for your help

Back to all forum threads · Log in to reply