JotForm and Zapier Integration to MySQL changing URL link from Uploaded fiels

  • Profile Image
    festivalnacionaldacancao
    Asked on May 13, 2014 at 12:34 PM

    Hello 

    I have a Zapier integration with MySQL 

    When Zapier inserts the data in the table. 

    URL that is being inserted is not the same 

    which is provided by JotForm 

    example 

    JotForm 

    https://www.jotform.com/uploads/festivalnacionaldacancao/40193325531346/265557026791187137/Staden-%20O%20perfume.mp3 

    ZAPIER 

    The http://www.jotform.com/uploads/festivalnacionaldacancao/40193325531346/265557026791187137/Staden- perfume.mp3

  • Profile Image
    TitusN
    Answered on May 13, 2014 at 04:02 PM

    Hello,

    Looks like Zapier is removing the whitespace placeholders (%20 O%20) for the upload URL.

    The name of the file is actually Staden- O perfume.mp3

    The spaces in the filename are translated as %20 when the file is uploaded to Jotform - and it looks like the integration may have a problem with this - possibly because %20 may be a system designated characer - either for Zapier or MySQL.

    My test with a similar Zapier integration did not show this behavior - but our settings might vary.

    Please check zapier's task history here: https://zapier.com/app/history

    Select the integration and find the transaction - expand the details so that you are able to see the URL that was sent - Is it the correct one?

    Similar scenario:

    If the link is correct - then MySQL is changing the link URL by removing the whitespace placeholders (%20)

    If the link is wrong - then we will forward this to our developers for futher advice.

    Looking forward to your response.

  • Profile Image
    festivalnacionaldacancao
    Answered on May 14, 2014 at 08:31 AM
    Hello
    In analyzing the situation, when I access JotForm is I download the
    Submissions, the informed File (Excel) URL is encrypted using the UTF-8
    format for URL.
    and when the Zapier make MySQL Integration with the same url
    is not encrypted
    Tiago Vital Pereira Gomes
    tiago@digisulnet.com.br
    (35) 3212-4922
    www.digisulnet.com.br
    2014-05-13 22:02 GMT+02:00 JotForm Support Forum :
    ...
  • Profile Image
    TitusN
    Answered on May 14, 2014 at 08:56 AM

    Hello,

    I have brought this behavior and your updates to the attention of our developers - they will advice further concerning the Jotform - Zapier - MySQL intergration.

    Thank you for your patience.

  • Profile Image
    liyam
    Answered on June 10, 2014 at 09:39 AM

    We apologize for the delayed update on this case, festivalnacionaldacancao,

    I've been trying to test the submissions from JotForm and I can't seem to find an issue on our end. May I request from you to please contact Zapier on this matter via https://zapier.com/support/.

    Please do keep us posted on this matter.

    Thanks.