Coupa Modeler Table Download

[#1]

Are you a supply chain professional? Does your heart skip a beat when you see the words “network optimization”? Do you like llamas?

If the answer is “yes”, then this macro is for you!

Coupa Modeler is the industry’s leading software tool for network optimization, and it has extensive API documentation that I used to develop this macro. Now you can easily bring the data from llama.ai into your Alteryx workflow.

Here are the steps that you need to take to get started:

1. Get your Model ID. It is a long string at the end of the url.

2. Obtain an API key (if you haven’t done so already). On llama.ai, click on the user icon and select “generate API key”. Put that somewhere safe! If you have an API key already, retrieve it. If you re-generate a new key, the old one will become inactive.  

3. Download this macro and paste your Model ID and your API key in  the corresponding fields in the text input tool.

4. Come now, click that run button! Now you have the “Products” table in your workflow and you can do any kind of data transformation with it.

 

As you adapt this to your needs, make sure you reference all tables by their “background” names. You can retrieve the list of “background” names here.

Examples:

“Products” - “Products”

“Sites” - “Sites”

“Network Work Center Summary” - “OptimizationOutputWorkCenterSummary”

“Cost to Serve Details” - “OptimizationOutputNetworkPathsDetails”

[bellosebastian]

Hi, Thank you very much for this. I'm having troubles running the macro. It seems that I'm missing a tool. Can you look into the image I'm attaching?

[m_v]

Hey, thanks for reaching out. Looks like it's not recognizing a macro within a macro. I have reuploaded the macro - now there is a "v2" attached, let me know if that works. 

[m_v]

New version of this macro is available here: https://community.alteryx.com/t5/Community-Gallery/Coupa-Llamasoft-Download-Model-Tables-v2024/ta-p/...