>100 Views
September 19, 18
スライド概要
2018/09/19 INTER-Mediator勉強会2018-#6発表資料
Web Application Developer / kintone CERTIFIED App Design Specialist 2020 / kintone CERTIFIED Customization Specialist 2020
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τϥΠΞϧ൛ • ࢼ༻ؒظ20189݄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/
FMDataAPI
FMDataAPI • ৽ډխߦࢯ͕։ൃ • FileMaker Data APIΛPHPͰར༻͢ΔͨΊ ͷϥΠϒϥϦ • MITϥΠηϯε 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
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Ͱಈ࡞