TOPHAP.EXCEL.yaml

name: TOPHAP
description: ''
host: EXCEL
api_set: {}
script:
  content: |-
    /**
     * Fetch property details for an address string.
     * Example: `console.log(await address('265 eagle ct', 'alamo', 'ca'))`
     * @customfunction
     * @param address
     * @param city
     * @param state
     * @returns {string[][]}
     */
    async function address(address: string, city: string, state: string) {
      if (!address) throw Error('missing address');

      const url = new URL('https://api.tophap.vercel.app/v1/excel');
      const query = [address, city, state].filter((x) => x).join(' ');
      url.searchParams.set('query', query);

      const headers = { tophap: 're3ZuR9m' };
      const res = await fetch(url.toString(), { headers });
      const data = await res.json();

      if (!res.ok) {
        const errmsg = (data ?.error ?? 'unknown error')
        return [[errmsg]]
      }

      const keys = [
        'county',
        'jurisdiction',
        'parcel_number',
        'property_type_use',
        'square_footage',
        'year_built',
        'land_acreage',
        'tax_year',
        'land_assessed_value',
        'improvements_assessed_value',
        'total_av',
        'land_market_value',
        'improvements_market_value',
        'total_market_value',
        'current_taxes',
        'owners',
        'last_sale_date',
        'last_sale_price',
        'hazards',
        'permit_count',
        'permit_history'
      ];

      const format = (value: any) => {
        if (value == null) return ''
        if (typeof value === 'number') return value
        if (typeof value === 'string') return value
        return JSON.stringify(value)
      }

      return [keys.map(key => format(data[key]))]
    }
  language: typescript
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js

  office-ui-fabric-js@1.4.0/dist/css/fabric.min.css
  office-ui-fabric-js@1.4.0/dist/css/fabric.components.min.css

  core-js@2.4.1/client/core.min.js
  @types/core-js

  jquery@3.1.1
  @types/jquery@3.3.1