INTER-Mediator 5.8とFileMaker Data API

INTER-Mediator 5.8ͱ FileMaker Data API 2018/09/19 INTER-Mediatorษ‫ڧ‬ձ2018-#6ൃදࢿྉ দඌಞʢ‫ࣜג‬ձࣾΤϛοΫʣ

Agenda • FileMaker Data API • FMDataAPI • INTER-Mediator 5.8

FileMaker Data API

FileMaker Data API • ‫ڞ‬༗σʔλϕʔεͷσʔλʹ Web αʔ Ϗε͔ΒΞΫηεͰ͖ΔΑ͏ʹ͢ΔΞ ϓϦέʔγϣϯϓϩάϥϛϯάΠϯλʔ ϑΣʔεʢʮFileMaker 17 Data API ΨΠ υʯΑΓʣ • Ԡ౴σʔλ͸JSON

όʔδϣϯ17Ͱਖ਼ࣜ൛ʹ • FileMaker 17Ͱਖ਼ࣜʹ౥ࡌ • FileMaker Server 17 • FileMaker Cloud 1.17

τϥΠΞϧ൛ͷ࢖༻‫ݶظ‬ • FileMaker Server 16ͱFileMaker Cloud 1.16ͷFileMaker Data API͸τϥΠΞϧ൛ • ࢼ༻‫ؒظ‬͸2018೥9݄27೔·Ͱ

Data API ϥΠηϯε • సૹྔʹԠͨ͡ϥΠηϯεϞσϧ • FileMaker Data API‫ܦ‬༝ͰFileMaker Server ʢFileMaker Cloudʣ͔Β֎෦΁σʔλΛ ૹ৴͢Δ௨৴ॲཧ͕ߦΘΕͨͱ͖ʹσʔ λసૹྔͱͯ͠Χ΢ϯτ

Data API ϥΠηϯε • 1ϥΠηϯε͋ͨΓ೥ؒ24GB͕όϯυϧ • 5ϢʔβϥΠηϯεͰ͸σʔλసૹྔ ͷ೥্ؒ‫ݶ‬͸120GB • ೥ؒData API ϥΠηϯεΛ௥Ճߪೖ͢Δ ৔߹ͷՁ֨͸24GB෼Ͱ6,480ԁʢ੫ผʣ

Data APIͰͰ͖Δૢ࡞ • ‫ڞ‬༗σʔλϕʔε΁ͷϩάΠϯ·ͨ͸ϩ άΞ΢τ • Ϩίʔυͷ࡞੒ɺฤूɺ࡟আɺऔಘɺ ·ͨ͸Ϩίʔυͷൣғͷऔಘ • ‫ࡧݕ‬ͷ࣮ߦ • άϩʔόϧϑΟʔϧυ஋ͷઃఆ

όʔδϣϯ17͔Βར༻Մೳ • FileMakerεΫϦϓτͷ࣮ߦ • ΦϒδΣΫτϑΟʔϧυ΁ͷσʔλͷ Ξοϓϩʔυ

όʔδϣϯ17͔Βར༻Մೳ • ֎෦FileMakerςʔϒϧͷσʔλ΁ͷΞΫ ηε • Ϩίʔυ·ͨ͸Ϩίʔυͷൣғͷऔಘ ࣌ʹ͓͚ΔԠ౴σʔλ΁ͷผͷϨΠΞ ΢τͷ࢖༻ʢlayout.responseҾ਺ʣ

αϙʔτ͞Εͳ͍‫ػ‬ೳ • ֎෦ODBCσʔλιʔεͷσʔλ΁ͷΞ Ϋηε • FileMakerϓϥάΠϯ

αϙʔτ͞Εͳ͍‫ػ‬ೳ • ϢʔβΠϯλϥΫγϣϯʹΑΔεΫϦ ϓττϦΨͷΞΫςΟϒԽ • αʔόʔϚγϯͷϑΝΠϧγεςϜ΁ͷ ΞΫηε • ྫɿGet (ςϯϙϥϦύε) ؔ਺

fmrest֦ுΞΫηε‫ݖ‬ • FileMaker Data API༻ͷ֦ுΞΫηε‫ݖ‬ Ωʔϫʔυ͸fmrest

Data APIͷυΩϡϝϯτ • FileMaker 17 Data API ΨΠυ https://fmhelp.filemaker.com/docs/17/ja/ dataapi/

• https://fmhelp.filemaker.com/docs/17/ja/dataapi/

FMDataAPI

FMDataAPI • ৽‫ډ‬խߦࢯ͕։ൃ • FileMaker Data APIΛPHPͰར༻͢ΔͨΊ ͷϥΠϒϥϦ • MITϥΠηϯε https://github.com/msyk/FMDataAPI

• https://github.com/msyk/FMDataAPI

FMDataAPIͷར఺ • σʔλϕʔε΁ͷ઀ଓʹඞཁͳΞΫηε τʔΫϯΛҙࣝͤͣʹ࢖͑Δ • SSLαʔόʔূ໌ॻΛ࣮ࡍʹಋೖ͠ͳ͘ ͯ΋։ൃͰ͖Δ࿮૊Έ͕͋Δʢӡ༻࣌ ʹ͸ূ໌ॻ͸ඞཁʣ • αʔόʔ໊ʹʮlocalserverʯΛࢦఆ

FMDataAPIʹؔ͢Δ৘ใ • https://blog.msyk.net/?s=FMDataAPI • https://www.famlog.jp/search?q=FMDataAPI • https://github.com/msyk/FMDataAPI

• https://blog.msyk.net/?s=FMDataAPI
• https://www.famlog.jp/search?q=FMDataAPI
• https://github.com/msyk/FMDataAPI

INTER-Mediator 5.8

INTER-Mediator 5.8 • FileMaker Data APIʹରԠ • FMDataAPIΛ౥ࡌ • ‫ࡏݱ‬Ӷҙ։ൃத • όʔδϣϯ5.8-RC2ΛϦϦʔεࡁΈ

CWP͔ΒData API΁ͷมߋ • INTER-MediatorͰ͸‫ج‬ຊతʹ ʮFileMaker_FXʯΫϥε͔Β ʮFileMaker_DataAPIʯΫϥεʹมߋͯ͠ αʔόʔ໊ʹʮlocalserverʯΛࢦఆ͢Δ ͚ͩ • ͍͔ͭ͘ཹҙ఺͋Γ

Data APIར༻࣌ͷཹҙ఺ • ϙʔλϧ໊ • άϩʔόϧϑΟʔϧυ஋ͷઃఆ • FileMakerεΫϦϓτͷ࣮ߦ

ϙʔλϧ໊ • ؔ࿈Ϩίʔυ͕‫·ؚ‬Ε͍ͯΔϙʔλϧ ͷσʔλΛѻ͏ʹ͸ϙʔλϧ໊Λࢦఆ ͢Δඞཁ͋Γ •

άϩʔόϧϑΟʔϧυ஋ͷ ઃఆ • ϨΠΞ΢τ໊ͱʢϦϨʔγϣϯγοϓ άϥϑ಺ͷʣςʔϒϧΦΧϨϯε໊͕ ҟͳΔ৔߹ʹ͸ʮςʔϒϧΦΧϨϯε ໊::ϑΟʔϧυ໊ʯͷ‫Ͱࣜܗ‬άϩʔόϧ ϑΟʔϧυΛࢦఆ͢Δඞཁ͋Γ

FileMakerεΫϦϓτͷ࣮ߦ • ࣮ߦ͢ΔεΫϦϓτͷ࠷‫ʹޙ‬Get ( ର ৅Ϩίʔυ਺ ) & "/" & Get ( Ϩίʔ υ૯਺ )Λ݁Ռͱͯ͠ฦ͢Α͏ʹʦ‫ࡏݱ‬ ͷεΫϦϓτऴྃʧεΫϦϓτεςο ϓΛೖΕΔඞཁ͋Γ

Data APIར༻࣌ͷཹҙ఺ • ‫͚͓ʹ఺࣌ݱ‬ΔFileMaker Data APIͷ࢓༷ ΍੍‫ىʹݶ‬Ҽ

·ͱΊ

·ͱΊ • INTER-Mediator͸όʔδϣϯ5.8Ͱ FileMaker Server 17ͷFileMaker Data API ʹਖ਼ࣜʹରԠ༧ఆ • PHPΛ࣮ߦͰ͖ΔWebαʔόʔΛซ༻ ͢Ε͹FileMaker Cloud 1.17Ͱ΋ಈ࡞