Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

162
Views
Google Firestore Cloud Function - problem with field path

I am trying to build cloud firestore scheduled function that select all documents with a certain condition (date less than Date.now) and then to update them one by one in two fields.

function is deployed successfully but when executed it returns the below error:

Error: Value for argument "fieldPath" is not a valid field path. Paths can only be specified as strings or via a FieldPath object.
at Object.validateFieldPath (/workspace/node_modules/@google-cloud/firestore/build/src/path.js:605:15)
at CollectionReference.where (/workspace/node_modules/@google-cloud/firestore/build/src/reference.js:1059:16)
at /workspace/index.js:8:12
at cloudFunction (/workspace/node_modules/firebase-functions/lib/cloud-functions.js:74:23)
at /layers/google.nodejs.functions-framework/functions-framework/node_modules/@google-cloud/functions-framework/build/src/function_wrappers.js:144:25
at processTicksAndRejections (node:internal/process/task_queues:96:5) 

I don't know so much with Java script but I am using the same syntax with flutter code and it is working correctly in the application.

what is the problem with the below js code?

const functions = require("firebase-functions");
const admin = require("firebase-admin");
admin.initializeApp();
const database = admin.firestore();
exports.testscheduledFunction = functions.pubsub.schedule("every 1 minutes").onRun(
      (context) => {
      database.collection("BusinessProfilesCollection")
      .where("Profile_pinning_ed" < admin.firestore.Timestamp.now())
      .get().then((snapshot) => {
        let i = 0;
        let tempid = "";
        console.log(snapshot.docs.length);
        for (i; i<snapshot.docs.length; i++) {
          tempid = snapshot.docs[i].id;
          database.collection("BusinessProfilesCollection").doc(tempid)
              .update({
                "Profile_pinning_status": "No",
                "Profile_pinning_ed": ""});
        }
      });
  return console.log(
      "Cloud Functions: Business Profiles Pinning is updated successfully");
});
about 4 years ago · Santiago Trujillo
1 answers
Answer question

0

Based on the code above, Firestore is reading your operator < as a field_path. Your field_path should be followed by a comma and make the operator string. See sample code below:

database.collection("BusinessProfilesCollection")
// Fixed query.
.where("Profile_pinning_ed", "<", admin.firestore.Timestamp.now())
.get().then((snapshot) => {
  let i = 0;
  let tempid = "";
  console.log(snapshot.docs.length);
  for (i; i<snapshot.docs.length; i++) {
    tempid = snapshot.docs[i].id;
    database.collection("BusinessProfilesCollection").doc(tempid)
        .update({
          "Profile_pinning_status": "No",
          "Profile_pinning_ed": ""});
  }
});

You may also check this documentation on how to perform Firestore queries:

  • Simple queries
about 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!