Create a URL with CONCAT and variable in the middle.

Kervin
Kervin Member
edited April 2022 in Magic ETL

CONCAT("https://b2b.officedepot.com/rest/ODServices/api/product/priceAvailability/xml?zipcode=XXXX,"&sku=", `VARIABLE` ,"&billto=XXXX)


I am trying to have a cell value where it shows VARIABLE . Everything else is part of a constant URL. I just can't get the variable To be in the middle of the URL. I have worked with others where the variable is on the end and looks like this


CONCAT('<a href="https://www.purchasingplatform.com/admin/products/', `PP Item #`, '" target="_blank">', `PP Item #`, '</a>')

Tagged:

Answers

  • I think your issue is around the double quotes in parts. Here is an example of how I did one similar where ClaimNumber is my variable name:

    CONCAT('<a href="https://mydomoinstance.domo.com/page/954056803?pfilters=[',
        '{%22column%22:%22ClaimNumber%22,%22operand%22:%22IN%22,%22values%22:[%22',
        `ClaimNumber`,
        '%22]}',
        ']" target="_blank">',
        `ClaimNumber`,
        '</a>')
    


    I found it worked best to break things up into more concat statements than technically necessary to deal with the quotes.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.