How to convert plain emails into adf format?
Status: Open · Asked by Christian Amaro on · 0 views
I am trying to send adf/xml emails such as this: https://adfxml.info/adf_spec.pdf
Does Pabbly allow to format into XML somehow?
Example of one email is this below, but of course dynamically change certain fields such as name/phone/email etc
1676668
2023-05-03T01:54:22+00:00
2016
Chrysler
300
295792
2C3CCAPG8GH295792
18495
Customer Name
[email hidden]
(888) 777-6666
Form Name: AIA - Lead - v3
Dealership Name
aderaco
Lead Generation - Facebook
Hey @amaro866
Can please tell us what is the use case you are trying to build here?
This is the universal format for passing contact information between the automotive industry.
This use case would be, I obtain a lead that includes Name / Email / Phone / Vehicle Details, then id need to email it in adf/xml format to our clients.
Also, same subject, notice the date format inside the example, are you able to format like that?
Date: 2023-05-03T01:54:22+00:00
Format: CCYY-MM-DDThh:mm:ss+hh:mm
Hey @amaro866
Currently, the action step to convert XML to plain text is not available on the platform.
But if you are trying to receive the XML in the webhook response you can use the "Webhook By Pabbly" trigger event.
I see.. What about date formatting?
Can you do this:
Format: CCYY-MM-DDThh:mm:ss+hh:mm
Example: 2023-05-03T01:54:22+00:00
Hey @amaro866,
You can format the date using the Date/Time Formatter Action Event
To rephrase my question, I want to webhook a date to Pabbly and have pabbly convert into the format in full.
Webhook: 03/05/2023
Pabbly Format: CCYY-MM-DDThh:mm:ss+hh:mm
Notice there is no time or timezone in the webhook.
Result: 2023-03-05T00:00:00+00:00
Can it do this?
Yes, it can do this. Please see the screenshot attached below.
Great, thank you for that.
Related question, this adf format uses IDs. For you workflow is your system able to move the numbers up by 1?
Such as workflow 1 is 1666666, then the next time the workflow triggers its 1666667?
Yes, you can use a counter for that, with an initial value of 1666666.
Great.
Regarding the date formatter, is there a way that it can detect which format is being sent and go down that workflow?
Example the one i provided earlier was : CCYY-MM-DDThh:mm:ss+hh:mm
But other types of emails will contact other variations like this:
CCYYMMDDThhmmss+hhmm
CCYYMMDDThhmmss-hhmm
CCYY-MM-DDThh:mm:ss-hh:mm
If someone sends in a different format is Pabbly able to read it and pull from it dynamically or is that a different workflow for each one?
Great.Regarding the date formatter, is there a way that it can detect which format is being sent and go down that workflow?
Example the one i provided earlier was : CCYY-MM-DDThh:mm:ss+hh:mm
But other types of emails will contact other variations like this:
CCYYMMDDThhmmss+hhmm
CCYYMMDDThhmmss-hhmm
CCYY-MM-DDThh:mm:ss-hh:mmIf someone sends in a different format is Pabbly able to read it and pull from it dynamically or is that a different workflow for each one?
Auto-detecting and dynamically pulling the date format is not possible.
