docasar
-
Content Count
42 -
Joined
-
Last visited
-
Hi, I am trying to work on a file that has predefined Get(UUIDNumber) for the parent keys, and I would like to change all those to Get(UUID). I wonder if I could use the Upgrade tool to just find and replace everywhere there it says Get(UUIDNumber) to Get(UUID) and also change the field type from Number to Text (this is because the file has more than 60 tables with their unique parent keys) I saw the blogpost from Dbservices but it was more as adding code not replacing code in FILE A with code from FILE B. Thank you so much for any help! Best regards, Docasar
-
upload pdf file to google drive without plugin
docasar replied to docasar's topic in FileMaker Pro 18 Advanced
Hi Tanya, I am sorry for the late reply... did you manage to do it? I put it on hold due to how difficult it was, but I found a workaround I need to try again. Best regards, Luis, from Spain -
Hello, I hope someone could just lead me in the right direction. We are based in Spain, and whenever I download any sample file most of the time it was created using US date format mm/dd/yyyy. Reading about using the Filemaker Migration Tool and the Helpers, I have manage to create a clone file. If I open the file before using the Migration Tool Helper, then the file takes System date format which is dd/mm/yyyy. BUT if I dont open the file (as it required for the migration tool to work) and I use the helper to do the migration (in this case DBservices one) then the Output File i
-
Hello, I am trying to download to our CRM all messages from Gmail account using the Gmail API. I have to do a first call to the API to get the first 1-100 messages IDs. With that call I get a nextPageToken that I can add to the url if I make a second call in order to get messages IDs from 101-200. So each time I make the call from Import from URL I get a $json in with the structure of: { "messages": [ users.messages Resource ], "nextPageToken": string, "resultSizeEstimate": unsigned integer } where [ users.messages Resource ] is a json array in th
-
upload pdf file to google drive without plugin
docasar replied to docasar's topic in FileMaker Pro 18 Advanced
Hi many thanks for your input. I reviewed the code and the $metadata is json = {"mimeType":"image/jpeg","name":"file.jpeg"} I am just trying to upload first a jpeg file on multipart POST, this is with the name and the type of file (extension). I found two articles in stackoverflow that first suggested to put the "char(13)&char(10)" after each line inside the body, but I think I am not putting them in the correct place because as I play around I get errors. I am pretty sure it is about one " that I am not properly formating... but cant figure out what it is. While there are -
upload pdf file to google drive without plugin
docasar replied to docasar's topic in FileMaker Pro 18 Advanced
Hello, I have edited my curl following the advise from other users in a different forum and looks like this: "-X POST" & " -H \"Authorization: Bearer " & API_tokens::access_token & "\"" & " -H \"Content-Type: multipart/related; boundary=foo_bar_baz\"" & " -H \"Content-Length: 119\"" & Char(13)&Char(10) & "--data-binary \"--foo_bar_baz" & Char(13)&Char(10) & "Content-Type: application/json; charset=UTF-8" & Char(13)&Char(10) & "--data-binary @$metadata" & Char(13)&Char(10) & Char(1 -
Hello, I am novice filemaker developer, and trying to learn the cool ways Filemaker can integrate with other apps. The "simple" task: upload document (.pdf) to Google Drive Folder with native filemaker funtions (no plugin). So far: I have managed to get the authorisation token (following Seedcode guide for Gmail integration and Harmonic DevCon18 presentation and demo files) and make the POST call to create a file in the Google Drive root folder, however the file is unreadable. So my guess is that I am not putting all the curl options correctly from what I understand from the Goo
-
UPDATE for NOVICE developers like myself: I finally found a solution, and apologise because I found that my first post wasn't completely right: 1) GetLayoutObjectAttribute ( "webviewer" ; "Content" ) on Filemaker Pro would actually get the modified DOM source code. 2) Since different webpages would run different scripts on Desktop version than on Mobile version (the one shown if using FILEMAKER GO), you can also get the DOM source code for the mobile version just by having an additional webviewer pointing to the mobile version of the url, normally if a web is: "htttps://www.name
-
I'm trying to insert the html code of a product page on a website for later Web Scraping Data. I am aware of the standard practice of using "Insert from URL" to get the source code, but I would only retrieve the content of the unmodified (pre-javascript altered) page, not the page after javascript has modified the DOM. Options I tried so far: 1) Make a webviewer from the url and use the GetLayoutObjectAttribute ( "webviewer" ; "Content" ) it shows the content of the unmodified (pre-javascript altered) page, not the page after javascript has modified the DOM on Filemaker Pro on m
-
Hello, I hope someone can bring light to the dark where I am at the moment with what seemed to be a simple script... So what I am trying to achieve is to print at once all open invoices from a current customer (in this case only 2 out of 3 invoices), so my script looks like this: Tables: ACT = Accounts INV= Invoices INL = Invoice Line Relationships: ACT (___ACT) = act_INV(__f_ACT) then I have from act_INV (___INV) = act_inv_INL (__f_INV) From Accounts Layout I have a portal that shows all invoices related to that account, and there I have placed a b
-
Ok... After LOTS of testing I figure out how it should be done, so I am just updating my own post to share the info in case anyother "amateur" developer as myself would encouter similar challenge I just figure out how to pass that "-d" data with the XML code, what I did was: 1) Create variable ( $rawdata ; <?xml version="1.0" encoding="UTF-8"?> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="SeguimientoEnviosRequest.xsd"><Solicitante>1</Solicitante><Dato>xxxxxxxxxxxxxxxx</Dato> </SeguimientoEnviosRequest>)
-
how to pass body raw as curl option for api integration
docasar replied to docasar's topic in FileMaker DataAPI
Ok... After LOTS of testing I figure out how it should be done, so I am just updating my own post to share the info in case anyother "amateur" developer as myself would encouter similar challenge I just figure out how to pass that "-d" data with the XML code, what I did was: 1) Create variable ( $rawdata ; <?xml version="1.0" encoding="UTF-8"?> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="SeguimientoEnviosRequest.xsd"><Solicitante>1</Solicitante><Dato>xxxxxxxxxxxxxxxx</Dato> </SeguimientoEnviosRequest>) -
Hi, I find my self hitting the wall, again and again, trying to make a POST call to an API using Insert from URL curl. When I try the code in POSTMAN it works very well, but trying to translate the curl options into Filemaker is where I fail. This is my POSTMAN code: curl -X POST \ https://www.correosexpress.com/wpsc/apiRestSeguimientoEnvios/rest/seguimientoEnvios \ -H 'user: username:passowrd' \ -H 'Content-Type: application/xml' \ -H 'Postman-Token: ff84b952-74c8-f06b-976d-f860d9d66de7' \ -d '<?xml version='\''1.0'\'' encoding='\''UTF-8'\''?><SeguimientoE
-
This is how postmant shows the cURL code: curl -X POST \ https://www.correosexpress.com/wpsc/apiRestSeguimientoEnvios/rest/seguimientoEnvios \ -H 'Authorization: Basic Zmxhc2thOmlUZnl4' \ -H 'Cache-Control: no-cache' \ -H 'Content-Type: application/xml' \ -H 'Postman-Token: ff84b952-74c8-f06b-976d-f860d9d66de7' \ -d '<?xml version='\''1.0'\'' encoding='\''UTF-8'\''?><SeguimientoEnviosRequest xmlns:xsi='\''http://www.w3.org/2001/XMLSchema-instance'\'' xsi:noNamespaceSchemaLocation='\''SeguimientoEnviosRequest.xsd'\''><Solicitante>x</Solicitante&
-
Hello, I am trying to connect to our current database with our shipping company so I can update the status of the delivered orders. To do that, I am currently using insert from URL and then parse the code to extract the info I need. However, I believe there should be a cleaner and safer way to do it using webservice. So I downloaded the documentation and looks very straightforward to set and I have been able to set up the POST and send it getting the data as XML using POSTMAN (as very well explained here: http://www.filemakerprogurus.com/filemaker-api-integration-salvatore-co