Step by Step Guide to Building an Odoo ERP API Integration in Go

Introduction

Hey there, fellow developer! Ready to dive into the world of Odoo ERP API integration using Go? You're in for a treat. Odoo's API is a powerhouse, and when combined with Go's simplicity and efficiency, you've got a recipe for some seriously cool integrations. Let's get cracking!

Prerequisites

Before we jump in, make sure you've got:

• Go installed (you're a pro, so I'm sure you do)
• An Odoo instance up and running
• Your API credentials handy

Got all that? Great! Let's move on.

Setting up the Go project

First things first, let's set up our project:

mkdir odoo-api-integration
cd odoo-api-integration
go mod init github.com/yourusername/odoo-api-integration

Now, let's grab the dependencies we'll need:

go get github.com/go-resty/resty/v2
go get golang.org/x/oauth2

Authentication

Alright, time to tackle authentication. Odoo uses OAuth2, so let's set that up:

import (
    "golang.org/x/oauth2"
)

func getOAuthConfig() *oauth2.Config {
    return &oauth2.Config{
        ClientID:     "your_client_id",
        ClientSecret: "your_client_secret",
        Endpoint: oauth2.Endpoint{
            AuthURL:  "https://your-odoo-instance.com/oauth2/auth",
            TokenURL: "https://your-odoo-instance.com/oauth2/token",
        },
        RedirectURL: "http://localhost:8080/callback",
        Scopes:      []string{"read", "write"},
    }
}

Basic API Operations

Now for the fun part - let's interact with the API:

import "github.com/go-resty/resty/v2"

func getProducts(client *resty.Client) ([]Product, error) {
    var products []Product
    _, err := client.R().
        SetResult(&products).
        Get("https://your-odoo-instance.com/api/product.template")
    return products, err
}

func createProduct(client *resty.Client, product Product) error {
    _, err := client.R().
        SetBody(product).
        Post("https://your-odoo-instance.com/api/product.template")
    return err
}

Advanced API Usage

Want to get fancy? Let's add some filtering and pagination:

func searchProducts(client *resty.Client, query string, limit int) ([]Product, error) {
    var products []Product
    _, err := client.R().
        SetQueryParams(map[string]string{
            "query": query,
            "limit": strconv.Itoa(limit),
        }).
        SetResult(&products).
        Get("https://your-odoo-instance.com/api/product.template/search")
    return products, err
}

Error Handling and Logging

Don't forget to handle those errors gracefully:

import "log"

func handleAPIError(err error) {
    if err != nil {
        log.Printf("API Error: %v", err)
        // Handle the error appropriately
    }
}

Testing

Testing is crucial, so let's write a simple test:

func TestGetProducts(t *testing.T) {
    client := resty.New()
    products, err := getProducts(client)
    if err != nil {
        t.Errorf("Error getting products: %v", err)
    }
    if len(products) == 0 {
        t.Error("No products returned")
    }
}

Performance Optimization

To keep things speedy, consider implementing caching:

import "github.com/patrickmn/go-cache"

var c = cache.New(5*time.Minute, 10*time.Minute)

func getCachedProducts(client *resty.Client) ([]Product, error) {
    if cachedProducts, found := c.Get("products"); found {
        return cachedProducts.([]Product), nil
    }
    products, err := getProducts(client)
    if err == nil {
        c.Set("products", products, cache.DefaultExpiration)
    }
    return products, err
}

Security Considerations

Always use HTTPS and store your credentials securely. Consider using environment variables:

import "os"

func getClientID() string {
    return os.Getenv("ODOO_CLIENT_ID")
}

Deployment

Docker makes deployment a breeze. Here's a simple Dockerfile:

FROM golang:1.16

WORKDIR /app

COPY go.mod ./
COPY go.sum ./
RUN go mod download

COPY *.go ./

RUN go build -o /odoo-api-integration

CMD [ "/odoo-api-integration" ]

Conclusion

And there you have it! You've just built a robust Odoo ERP API integration in Go. Pretty cool, right? Remember, this is just the beginning. There's so much more you can do with Odoo's API. Keep exploring, keep coding, and most importantly, have fun!

Code Repository

Want to see the full project? Check it out on GitHub: Odoo API Integration in Go

Now go forth and integrate! 🚀