Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

docasar

Members
 View Profile  See their activity

  • Content Count

    40

  • Joined

  • Last visited

Community Reputation

0 Neutral

About docasar

  • Rank
    member

Profile Information

  • Title
    PROGRAMER
  • Industry
    Distribution

FileMaker Experience

  • Skill Level
    Beginner
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. docasar started following upload pdf file to google drive without plugin, Clone file not taking system date format when using migration tool? and how to join two Json Arrays
  2. docasar
    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
  3. docasar
    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
  4. docasar
    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
  5. docasar
    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
  6. docasar
    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
  7. docasar
    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
  8. docasar
    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
  9. docasar
    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
  10. docasar
    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>)
  11. docasar
    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>)
  12. docasar
    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
  13. docasar
    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&
  14. docasar
    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
  15. docasar
    Hi Lee, Many thanks for your reply I apologize if my question may lead to confusion... Exactly, I would like to download the Excel file from a webpage (insert from URL) and then use the Excel file to create or update new records. It is important that I a container is involved so it doesnt matter from which device the import is made (no path related recurring import). Does this make any sense? Thanks a lot!
  16. docasar
    Hi, I have a similar situation where I would like to use insert from URL to import an Excel file into a container and then once the Excel file is on my database use it as a source for updating records with the information that the excel file contains. Until now I could only use a file stored on my computer... any ideas if it is possible to set a content of a container field as the source for an import file? Many thanks!
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept