---
# System prepended metadata

title: core mysql->postgres

---

# core mysql->postgres
## to do
```bash=

```
### complex query 
```bash=
curl --request GET \
  --url 'https://api-beta.evaly.com.bd/core/v2/merchant/orders/delivered/analytics/shop?page=1&order_status=delivered&shop=the-new-vision' \
  --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6IjAxMjAwMDAwMDA2IiwiZ3JvdXBzIjpbXSwiZmlyc3RfbmFtZSI6IkZvcmVzdCIsImxhc3RfbmFtZSI6IlByb2hhc2thIiwiaXNfc3RhZmYiOmZhbHNlLCJpc19hY3RpdmUiOnRydWUsImlzX3N1cGVydXNlciI6ZmFsc2UsInZlcmlmaWVkIjpmYWxzZSwidXNlcl90eXBlIjoiY3VzdG9tZXIiLCJ1c2VyX3N0YXR1cyI6ImFjdGl2ZSIsImVtYWlsIjoiIiwiY29udGFjdCI6IjAxMjAwMDAwMDA2IiwiZGF0ZV9qb2luZWQiOiIyMDIxLTA4LTA4VDA3OjA4OjIyLjc5M1oiLCJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiaXNfZWF1dGgiOnRydWUsImV4cCI6MTYyOTYyMTMyNH0.fFHMy-rvP-iAzujCPXOXWjnAINKQbULf7bsTP3y-ZYI'
```
## done

```bash=
curl --request GET \
  --url 'http://localhost:8000/v2/merchant/orders/sales-growth?shop=the-new-vision&year=2020' \
  --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6IjAxMjAwMDAwMDA2IiwiZ3JvdXBzIjpbXSwiZmlyc3RfbmFtZSI6IkZvcmVzdCIsImxhc3RfbmFtZSI6IlByb2hhc2thIiwiaXNfc3RhZmYiOmZhbHNlLCJpc19hY3RpdmUiOnRydWUsImlzX3N1cGVydXNlciI6ZmFsc2UsInZlcmlmaWVkIjpmYWxzZSwidXNlcl90eXBlIjoiY3VzdG9tZXIiLCJ1c2VyX3N0YXR1cyI6ImFjdGl2ZSIsImVtYWlsIjoiIiwiY29udGFjdCI6IjAxMjAwMDAwMDA2IiwiZGF0ZV9qb2luZWQiOiIyMDIxLTA4LTA4VDA3OjA4OjIyLjc5M1oiLCJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiaXNfZWF1dGgiOnRydWUsImV4cCI6MTYyOTYzNTkyN30.0mZEghIKLQCv_zzAoNo63wo9hOCIK97Fju2Ey8FtCcs'
```
