Cloud Backend (Cloud DB, API Builder)

• 

  how does the openvm code editor work?
  • Linda MacDonald  

  2
  0
  Votes
  2
  Posts
  14
  Views

  

  Hey Linda, OpenVM is a bit out of topic here (cloudbackend) We plan to open a new community for OpenVM soon You might check the STRAPI quickstart guide here: https://strapi.io/documentation/developer-docs/latest/getting-started/quick-start.html#_8-publish-the-content When you are in VS Code, in the left panel you must click on open folder and select the folder where you have deployed you files, or the default path "/opt/app/strapi/" You can also open a Terminal in the left menu, this way you can run any commands indicated in Strapi documentation
• 

  is it possible to run a pug app on appdrag with nodejs and mongodb?
  • Linda MacDonald  

  18
  0
  Votes
  18
  Posts
  75
  Views

  

  @Joseph-Benguira excellent thanks and can I upload a gatsby js frontend for it? If yes which option on the dashboard do I choose for that?
• 

  Node v.14 and/or ES2020
  • Daniel Mulroy  

  3
  0
  Votes
  3
  Posts
  16
  Views

  J

  Great news, Node.js 14 is now available on Cloudbackend, more details are available here: https://changelog-8f2785.appdrag.com/features/nodejs-14-serverless
• 

  is it possible to feed info from our database into the pagebuilder with the chart plugin?
  • Linda MacDonald  

  2
  0
  Votes
  2
  Posts
  8
  Views

  

  Hi, Yep you can export your database to CSV and import it. There's no direct way or synchronous way to achieve it.
• K

  Can I leverage socket.io via the API Builder or Page builder?
  • Konrad Hylton  

  5
  0
  Votes
  5
  Posts
  33
  Views

  

  @Joseph-Benguira your plans around cloudgate sound phenomenal ️ +1
• F

  Scheduling API calls based on day of the week
  • Franck Sayada  

  2
  0
  Votes
  2
  Posts
  7
  Views

  

  Hey Franck, yes it's possible, when you configure your scheduling select "Every-week" in the recurrence type dropdown you can then indicate the days of the week and hour
• J

  Importing google sheets to create a data base
  • Jean Yves Dhenain  

  3
  0
  Votes
  3
  Posts
  12
  Views

  E

  Hi Jean, another option may be to try a csv to sql converter, i.e. https://www.convertcsv.com/csv-to-sql.htm Then go to your Cloud Backend > Databases > New query The copy the sql code to create the table I've actually built my own tool to create this 'create table' sql code to quickly replicate FileMaker tables in AppDrag
• 

  Appdrag CLI tool
  • Daniel Mulroy  

  4
  0
  Votes
  4
  Posts
  29
  Views

  

  I do see that when you sync it down, you have a 'config file' (api.json) with the relevant metadata. Here's a sample: "appId": "abcd-1234", "funcs": { "/": [ // filepath { "id": 1234, // function ID "name": "myGreatFunction", function Name "description": "", "type": "nodejs12.x", "contentType": "FILE", "method": "PUT", "ram": 128, "timeout": 15, "output": "JSON" }, //etc. My suggestion is, maybe the fs pull can (either by default or with an arg) write the APIs in the correct folder structure, with the function names. Then, when uploading, it can match the filenames/paths with the JSON config file in order to upload it back to the server in the right place. This is a huge difference between something like AppDrag and Netlify or others. I love AppDrag but I'm spending a LOT of time trying to do simple things like sync my code to gitHub or work effectively locally in VS Code without copy/pasting code by hand back and forth.
• 

  Rotating/Changing API Key
  • Daniel Mulroy  

  7
  0
  Votes
  7
  Posts
  26
  Views

  

  @Daniel-Mulroy said in Rotating/Changing API Key: Thanks @Wassim that helps. Does that mean the environment vars are 'hardcoded' into the version of the script that is published? more info here : https://docs.aws.amazon.com/lambda/latest/dg/configuration-envvars.html You define environment variables on the unpublished version of your function. When you publish a version, the environment variables are locked for that version along with other version-specific configuration.
• N

  Database and prevention/alert in case of overflow
  • Nicolas Flam  

  3
  0
  Votes
  3
  Posts
  15
  Views

  N

  Thank You Wassim.
• M

  Regster API Function.
  • malky shlomowith  

  8
  0
  Votes
  8
  Posts
  31
  Views

  

  https://www.npmjs.com/package/appdrag-cloudbackend You can JSON.parse(response); and check numberOfAffectedRows.
• 

  [Bug] Upload file through Cloud DB UI
  • Pierre SULPICE  

  4
  0
  Votes
  4
  Posts
  28
  Views

  

  Can you share a link to support@appdrag.com with the steps to reproduce?
• 

  install.sh when using appdrag-cli tool?
  • Daniel Mulroy  

  1
  0
  Votes
  1
  Posts
  13
  Views

  No one has replied

• 

  Is the AppDrag function name (or URL?) available from within an API Function?
  • Daniel Mulroy  

  4
  0
  Votes
  4
  Posts
  18
  Views

  

  @Wassim said in Is the AppDrag function name (or URL?) available from within an API Function?: Seems a very good and practical way to do it. You can also manually define it in your API functions while setting sentry up no? Yes, I could, but I'm looking for reusable / template code I can copy/paste very quickly between functions and/or use in my template library... so I don't want to think about it each time, just want it to work every time For reference, here's my final code to get the function name both during testing "Try" in CloudBackend and also when the function is called 'normally': module.exports.getFunctionInfo = (event, context) => { let fInfo = {}; // Try to extrapolate function info // sometimes the from-url is not available, so wrapping this in a try/catch block try { const httpMethods = ["GET", "POST", "PUT", "DELETE", "PATCH"]; var functionHandle = event.HEADERS['from-url'].split('/').slice(-1)[0]; // Get from URL if it's been called from the web for (let method of httpMethods) { // Get from parameters if it's been called from "Try" method, because above method will not work. Could also ignore errors if running from Try Now as they are likely development errors.... if (event[method] && event[method].APPDRAG_FUNCTION_NAME != null) functionHandle = event[method].APPDRAG_FUNCTION_NAME; } fInfo.functionHandle = functionHandle; } catch (e) { fInfo.functionHandle = ""; } fInfo.functionVersion = context.functionVersion; fInfo.functionName = context.functionName; return fInfo; };
• 

  [Bug] - can't share more than one CloudDB folder with an external email address?
  • Daniel Mulroy  

  2
  0
  Votes
  2
  Posts
  10
  Views

  

  Hello, Exactly, thanks to you for finding this issue! This has been corrected, it will be live tomorrow.
• 

  how do we install node packages? + how to save app credentials in the env section
  • Linda MacDonald  

  6
  0
  Votes
  6
  Posts
  18
  Views

  

  Hey, yes you can call it whatever you want as they are just variable names. You just have to use the same name when using process.env.yourVariable. Your code will use the computed value of it so the name has no impact. (unless a library specifically use inside its code process.env.whateverVariable)
• 

  [Urgent] Mailing by API
  • Pierre SULPICE  

  15
  0
  Votes
  15
  Posts
  58
  Views

  J

  Hey Pierre, please ensure the email sender address configured in your whitelabel settings is validated or else indeed no emails will be sent Another option is to clear the sender email address field in your whitelabel settings
• S

  Creating front end links
  • Stephen Bower  

  1
  0
  Votes
  1
  Posts
  10
  Views

  No one has replied

• T

  Retrieve visitor country code?
  • ThomasD  

  9
  0
  Votes
  9
  Posts
  39
  Views

  T

  @Wassim Super, then I don't need to worry about that
• 

  How do I store a file with GOOGLE_APPLICATION_CREDENTIALS needed for Firebase Auth?
  • Ugnius Ramanauskas  

  2
  0
  Votes
  2
  Posts
  10
  Views

  

  Hey Ugnius, in the env variable settings, add a new env var, name it "googleJSON" for eg. but you can name it as you want on the right side, as value, paste the whole text content of the json file you have from google. var googleJSON = JSON.parse(process.env.googleJSON); admin.initializeApp({ credential: admin.credential.cert({ projectId: googleJSON.project_id, clientEmail: googleJSON.client_email, privateKey: googleJSON.private_key }), databaseURL: "https://<DATABASE_NAME>.firebaseio.com" }); Just a small thing, whenever you can you should avoid Google! Google deprecates API and services every week and providing nearly zero warning to "customers", in fact they have no respect at all for developers using their services and it's nearly impossible to talk with someone there. So if you want your service to be down in the next 6 months because it's deprecated without any notice ... sure go with google
• T

  Admin VS front-end input inconsistencies...
  • ThomasD  

  8
  1
  Votes
  8
  Posts
  36
  Views

  T

  @Wassim Wonderful, thanks!
• 

  Table Column Default Value
  • Dick Honing  

  3
  0
  Votes
  3
  Posts
  9
  Views

  

  I have been wishing for this. @Wassim Would it be possible to choose to use an integer or a UUID for the default 'id' / index column?
• 

  How to increase results in Visual Sql Select
  • Marc Lamouret  

  2
  0
  Votes
  2
  Posts
  9
  Views

  

  Hi Marc, wish you're fine! On Visual SQL Select if you look at the documentation there are those parameters to determine the page size and page number to avoid people to fetch too many rows when it's not needed. If you really need to fetch more results: Set the pageSize to a higher value Use Raw SQL Select
• G

  Where is the data hosted? EU or USA?
  • Gerson Kramer  

  5
  0
  Votes
  5
  Posts
  26
  Views

  

  Hey Gerson, I can confirm that all the data on AppDrag is stored only in EU (AWS EU-WEST-1, in Dublin, Ireland)
• 

  [TM] Importing CSV
  • Pierre SULPICE  

  5
  0
  Votes
  5
  Posts
  14
  Views

  

  That was so obvious... I don't know why I was going that far.... thanks a lot !
• 

  [TM] Cloud DB UI - Pagination issue
  • Pierre SULPICE  

  4
  0
  Votes
  4
  Posts
  24
  Views

  

  Hello, Sorry for the late reply, it works like a charm, thanks See you soon,
• 

  is there a way to connect to the database when developing locally?
  • Linda MacDonald  

  9
  0
  Votes
  9
  Posts
  32
  Views

  

  @Daniel-Mulroy thank you so much for this🤩...hope it didnt disturb your work flow you're in luck, am on windows so once I get up and running I'll let you know
• 

  the cli takes my whole rootfolder to be a file
  • Linda MacDonald  

  3
  0
  Votes
  3
  Posts
  9
  Views

  

  hey there @Daniel-Mulroy I took another look at it and as it turned out I did have a zip file which I uploaded...the app is running on appdrag but for sure I'll try the / at the end next time cause it was rather peculiar error message and even more peculiar since it did what it was meant to do
• 

  how do I switch back to that pretty cards preview on the template db folder?
  • Linda MacDonald  

  3
  0
  Votes
  3
  Posts
  10
  Views

  

  @Daniel-Mulroy you're pure magician!! - I've gotten it back!!! thanks a mil
• 

  How to save uploaded file in Custom Folder ?
  • vinoth kumar  

  3
  0
  Votes
  3
  Posts
  19
  Views

  

  @Joseph-Benguira Thanks Joseph. Also i have another doubt. What's the max file size we can upload in CloudBackEnd ? I tried to upload a file size of 55 mb. It doesn't worked.
• 

  how to implement a node/vue js app?
  • Linda MacDonald  

  11
  0
  Votes
  11
  Posts
  66
  Views

  

  Here is the link to our CLI tool: https://www.npmjs.com/package/appdrag
• 

  How to use Foreign Key concept ?
  • vinoth kumar  

  3
  0
  Votes
  3
  Posts
  17
  Views

  

  @Joseph-Benguira, Thanks. Will give a try.
• 

  how to add longditude/langditude to DB - float?
  • Linda MacDonald  

  8
  1
  Votes
  8
  Posts
  33
  Views

  

  @Joseph-Benguira yup atlas is cool, was just wondering if you where considering getting it into the appdrag ecosystem
• 

  [TM] Private code
  • Pierre SULPICE  

  5
  0
  Votes
  5
  Posts
  26
  Views

  

  Well it's not THAT sensitive indeed, it was more like macros for table names and preprod names and stuff like that to avoid to repeat it and be able to change it easily. I know the Database and stuff like that are protected but I'm thinking that it's still the bed idea to spread all the accurate name of everything that easily ^^" Problem with the Env Variables is that they are contained only in the func where I write them, so it's not helping that much for this specific usage. I don't really like the idea of having an API call "just for that", especially when I'll use it a lot for my tracking system, the goal is more to reduce them So it's not an ABSOLUTE NEED but it might be very handy to add some genericity in my code. For now I'll not do it, I'll let you know if I come up with a cool system to do it painlessly See you soon,
• 

  High Volume Email sending - rate limiting? Queueing?
  • Daniel Mulroy  

  8
  2
  Votes
  8
  Posts
  44
  Views

  

  In fact we have a much larger allowance on AWS SES (few hundreds per sec) and it's shared by all appdrag customers. I'll check but I don't think we have any hard limit per user on our side.
• 

  [TM] Broken Database
  • Pierre SULPICE  

  8
  0
  Votes
  8
  Posts
  30
  Views

  

  Oops, I misunderstood!
• 

  Protected External link to Cloud DB
  • Pierre SULPICE  

  4
  0
  Votes
  4
  Posts
  22
  Views

  

  @Wassim Thanks for the reply ! I think it's not useful enough to ask for the new feature directly, but for exemple I have inscriptions I would like to share dynamically to someone that doesn't have an AppDrag account and it's painful to make him create one in his situation ^^" The only solution I then have is an open link, but it's kind of sensitive so it's not the best to "open" it. I can extract them regularly ofc but it's less dynamic all of a sudden ^^" Thanks for your answer anyway !
• 

  Email with attachments
  • vinoth kumar  

  4
  0
  Votes
  4
  Posts
  27
  Views

  

  Perfect !
• T

  This topic is deleted!
  • ThomasD  

  6
  0
  Votes
  6
  Posts
  8
  Views
• T

  Ran out of API calls per minute, but no one's using it...
  • ThomasD  

  15
  0
  Votes
  15
  Posts
  29
  Views

  T

  @Wassim Thanks it all makes sense now. I was about to use the Starter Tier for our use-cases, since I think that's the minimum required and also use 1 minute cache. I'll probably make a calculator for back-end, so I don't lock myself into unnecessary billings, maybe it could be useful for the community too.