# Sql 쿼리 조회 데이터와 api 조회 데이터를 맵핑하는 방법

**URL:** <https://ask.selectfromuser.com/t/sql-api/98>\
**Category:** 사용 팁\
**Tags:** responsefn\
**Created:** [2월 15, 2024, 7:16오전 UTC](https://ask.selectfromuser.com/t/sql-api/98 "2024-02-15T07:16:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hbkim](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/hbkim/32/23_2.png) [@hbkim](https://ask.selectfromuser.com/u/hbkim)\
**Post date:** [2월 15, 2024, 7:16오전 UTC](https://ask.selectfromuser.com/t/sql-api/98/1 "2024-02-15T07:16:11Z")

</div>

![image](https://canada1.discourse-cdn.com/flex032/uploads/selectfromuser/original/1X/31e38ab12be527ab9ee8fe91a9b3ab86a2e8da28.png)

responseFn을 통해 쿼리 블록과 HTTP 블록의 조회 데이터를 맵핑해서 보여줄 수 있어요.

관련 문의는 댓글이나 서비스내 채팅으로 문의주세요! 감사합니다.

```yaml
  blocks:
    - type: http
      axios:
        url: https://api.selectfromuser.com/sample-api/products
        method: GET
      rowsPath: rows
      id: getProducts
      hidden: true
      autoload: false    
      
    - type: query
      resource: mysql.qa
      sqlType: select
      sql: >
        SELECT id, name, vintage FROM wine_stock LIMIT 10

      responseFn: |
        console.log('getProducts', getProducts)
        
        const _products = await getProducts.trigger()
        const products = _products?.rows || []
        console.log('products', products)

        return rows.map(row => {
          const product = products.find(e => e.id == row.id) || {}
          row.external_name = product.name
          return row
        })
      searchOptions:
        enabled: true
      paginationOptions:
        enabled: true
        perPage: 10
      showDownload: csv

```

---

<div class="post-metadata">

**Author:** ![hbkim](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/hbkim/32/23_2.png) [@hbkim](https://ask.selectfromuser.com/u/hbkim)\
**Post date:** [2월 15, 2024, 7:20오전 UTC](https://ask.selectfromuser.com/t/sql-api/98/2 "2024-02-15T07:20:56Z")

</div>

JSON 데이터를 그대로 보여주고 싶으신 경우 `format: json` 을 활용하시면 됩니다.

클릭시 JSON viewer를 띄워줍니다.

> **[columns: {} | selectfromuser.com](https://docs.selectfromuser.com/columns#format-json-json-inline)**
>
> Select Admin